Select all employees — SQL | Toolliyo Academy

Problem

Write SQL to list all columns from Employees.

Hints

SELECT * FROM Employees

Your practice code

Ready — edit the code above and click Run.

Solution

-- Sample schema
CREATE TABLE Employees (Id INT, Name TEXT, DeptId INT, Salary INT);
CREATE TABLE Departments (Id INT, Name TEXT);
INSERT INTO Employees VALUES (1,'Ali',1,90000),(2,'Sara',2,120000),(3,'Raj',1,75000);
INSERT INTO Departments VALUES (1,'Engineering'),(2,'Sales');
SELECT * FROM Employees;

Try solving on your own first, then reveal the official answer.

Explanation

SELECT * returns all columns—prefer explicit column lists in production.