Skip to content
SQL Short Reads
SQL Short Reads: Where Short Reads Lead to SQL Expertise.
Menu and widgets
SQL SHORT READS
No calendar table? No problem!
SQL Antipatterns: Using Ordinals in GROUP BY and ORDER BY Clauses
Conveying Respect and Kindness Through Readable Code
SQL FUNDAMENTALS
THE BIG SIX
SELECT CLAUSE
FROM CLAUSE
WHERE CLAUSE
GROUP BY CLAUSE
HAVING CLAUSE
ORDER BY CLAUSE
JOINS
CROSS JOIN
FULL JOIN
LEFT JOIN
INNER JOIN
RIGHT JOIN
SELF JOIN
UNION & UNION ALL
CASE EXPRESSIONS
FUNCTIONS
SINGLE-ROW FUNCTIONS
CHARACTER FUNCTIONS
DATETIME FUNCTIONS
HANDLING MISSING VALUES/NULLS
NUMERIC FUNCTIONS
AGGREGATE FUNCTIONS
AVG
COUNT
MIN
MAX
SUM
WINDOW/ANALYTIC FUNCTIONS
AGGREGATES WITH WINDOWS
RANKING FUNCTIONS
ROW REFERENCE FUNCTIONS
SUBQUERIES
FROM CLAUSE
HAVING CLAUSE
WHERE CLAUSE
SELECT CLAUSE
COMMON TABLE EXPRESSIONS
RECURSION
VIEWS
SQL PRACTICE PROBLEMS
EASY
MEDIUM
HARD
SUPPORT SQL SHORT READS
ABOUT SQL SHORT READS
Twitter
LinkedIn
YouTube
DENSE RANK
