✅ Top 20 SQL Queries (With Query Names)
1. 1. Retrieve All Records
sql
CopyEdit
SELECT * FROM employees;
2. 2. Retrieve Specific Columns
sql
CopyEdit
SELECT name, salary FROM employees;
3. 3. Filter Records Using WHERE Clause
sql
CopyEdit
SELECT * FROM employees WHERE department = 'HR';
4. 4. Sort Records in Descending Order of Salary
sql
CopyEdit
SELECT * FROM employees ORDER BY salary DESC;
5. 5. Find Highest Salary in the Table
sql
CopyEdit
SELECT MAX(salary) FROM employees;
6. 6. Find Second Highest Salary
sql
CopyEdit
SELECT MAX(salary)
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);
7. 7. Count Total Number of Employees
sql
CopyEdit
SELECT COUNT(*) FROM employees;
8. 8. Count Employees Grouped by Department
sql
CopyEdit
SELECT department, COUNT(*)
FROM employees
GROUP BY department;
9. 9. Find Average Salary per Department
sql
CopyEdit
SELECT department, AVG(salary)
FROM employees
GROUP BY department;
10. 10. List Employees Who Joined After a Specific Date
sql
CopyEdit
SELECT * FROM employees
WHERE joining_date > '2020-01-01';
11. 11. Find Names Starting with 'A'
sql
CopyEdit
SELECT * FROM employees
WHERE name LIKE 'A%';
12. 12. Use IN Operator to Filter Multiple Departments
sql
CopyEdit
SELECT * FROM employees
WHERE department IN ('HR', 'Finance');
13. 13. Use BETWEEN Operator to Find Salary Range
sql
CopyEdit
SELECT * FROM employees
WHERE salary BETWEEN 30000 AND 60000;
14. 14. Find Duplicate Employee Names
sql
CopyEdit
SELECT name, COUNT(*)
FROM employees
GROUP BY name
HAVING COUNT(*) > 1;
15. 15. Get Unique Department Names
sql
CopyEdit
SELECT DISTINCT department FROM employees;
16. 16. Join Employees with Department Table (INNER JOIN)
sql
CopyEdit
SELECT [Link], d.department_name
FROM employees e
INNER JOIN departments d
ON e.department_id = [Link];
17. 17. LEFT JOIN to Show All Employees Even Without Department
sql
CopyEdit
SELECT [Link], d.department_name
FROM employees e
LEFT JOIN departments d
ON e.department_id = [Link];
18. 18. Subquery: Find Employees Earning Above Average Salary
sql
CopyEdit
SELECT name
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);
19. 19. Find Employee(s) with Maximum Salary
sql
CopyEdit
SELECT *
FROM employees
WHERE salary = (SELECT MAX(salary) FROM employees);
20. 20. Delete Employees With Low Salary
sql
CopyEdit
DELETE FROM employees
WHERE salary < 20000;