Top SQL Queries for Practice (With Short Answers) - Basic Select Queries (1–15)

 

1. Fetch all records from Employee table

    SELECT * FROM Employee;

2. Fetch only employee names

    SELECT emp_name FROM Employee;

3. Fetch unique department names

    SELECT DISTINCT department FROM Employee;

4. Fetch employees with salary > 50000

    SELECT * FROM Employee WHERE salary > 50000;

5. Fetch employees from HR department

    SELECT * FROM Employee WHERE department = 'HR';

6. Fetch employees with salary between 30000 and 60000

    SELECT * FROM Employee WHERE salary BETWEEN 30000 AND 60000;

7. Fetch employees in HR or IT

    SELECT * FROM Employee WHERE department IN ('HR','IT');

8. Fetch employees whose name starts with A

    SELECT * FROM Employee WHERE emp_name LIKE 'A%';

9. Fetch employees whose name ends with n

    SELECT * FROM Employee WHERE emp_name LIKE '%n';

10. Fetch employees whose name contains 'ar'

    SELECT * FROM Employee WHERE emp_name LIKE '%ar%';

11. Fetch employees with NULL manager_id

    SELECT * FROM Employee WHERE manager_id IS NULL;

12. Fetch employees sorted by salary ascending

    SELECT * FROM Employee ORDER BY salary ASC;

13. Fetch employees sorted by salary descending

    SELECT * FROM Employee ORDER BY salary DESC;

14. Fetch top 5 highest paid employees

    SELECT TOP 5 * FROM Employee ORDER BY salary DESC;

15. Fetch first 5 rows (MySQL)

    SELECT * FROM Employee LIMIT 5;