Common SQL Syntaxes

1. Select Statement:

SELECT column1, column2, ...
FROM table_name;

2. Where Clause:

SELECT *
FROM table_name
WHERE condition;

3. Order By:

SELECT *
FROM table_name
ORDER BY column1 ASC, column2 DESC;

4. Join:

SELECT table1.column1, table2.column2
FROM table1
JOIN table2
ON table1.common_column = table2.common_column;

5. Aggregate Functions:

SELECT SUM(column1), AVG(column2), COUNT(column3)
FROM table_name;

6. Group By:

SELECT column1, SUM(column2)
FROM table_name
GROUP BY column1;

7. Having Clause:

SELECT column1, SUM(column2)
FROM table_name
GROUP BY column1
HAVING SUM(column2) > 100;

8. Insert Statement:

INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);

9. Update Statement:

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

10. Delete Statement:

DELETE FROM table_name
WHERE condition;

11. Subqueries:

SELECT *
FROM table1
WHERE column1 IN (
  SELECT column2
  FROM table2
  WHERE condition
);

12. Unions:

SELECT column1, column2
FROM table1
UNION
SELECT column1, column2
FROM table2;