Enough SQL

Latest version of SQL is 2016.

• Use uppercase for SQL key words; Lowercase for identifiers

Naming

• Table in plural
• Column in singular

SQL 96

SELECT <expressions>
FROM <table>
JOIN table
ON <join condition>
WHERE <predicate>
GROUP BY <expressions>
HAVING <predicate>
ORDER BY <expressions>
LIMIT <number of results>