A Comment on Comments

How to Group Data in SQL With a Catch-All Bucket

How to Simulate the GROUP_CONCAT Function

Singular vs. Plural Table Names

Tips and Tricks for Bitwise Arithmetic

How to Simulate the SQL ROW_NUMBER Function

Less Is More

The Difference Between Subqueries and Derived Tables in SQL

How to Write INSERT if NOT EXISTS Queries in Standard SQL

How to Write a SQL Exclusion Join

How to Write a UNION in SQL Without Using UNION

Interactive Directory Merging

Mutex Tables in SQL

How to Write Subqueries Without Using Subqueries in SQL

Essential Books

Small Wins, Then Big Wins