✅ SQL Clauses Cheat Sheet! 🧠📘

1️⃣ SELECT – Pick the columns you want

SELECT name, age FROM students;

2️⃣ WHERE – Filter rows based on condition

SELECT * FROM orders WHERE status = 'delivered';

3️⃣ ORDER BY – Sort the results

SELECT * FROM products ORDER BY price DESC;

4️⃣ GROUP BY – Group rows for aggregation

SELECT department, COUNT(*) FROM employees GROUP BY department;

5️⃣ HAVING – Filter groups after aggregation

SELECT department, COUNT(*) FROM employees  
GROUP BY department HAVING COUNT(*) > 5;

6️⃣ LIMIT / TOP – Restrict number of rows 
-- MySQL/PostgreSQL

SELECT * FROM sales LIMIT 10;

-- SQL Server

SELECT TOP 10 * FROM sales;

7️⃣ DISTINCT – Remove duplicates

SELECT DISTINCT city FROM customers;

8️⃣ BETWEEN – Filter within a range

SELECT * FROM invoices WHERE amount BETWEEN 100 AND 500;

9️⃣ IN – Match any from a list

SELECT * FROM users WHERE role IN ('admin', 'manager');

🔟 ALIAS (AS) – Rename columns or tables

SELECT name AS EmployeeName FROM employees;

💡 Tip: Combine clauses for powerful queries!

♥️ Double Tap if you found this helpful!