SQL
SELECT Basics: Columns, SELECT * and Aliases
The statement you will write more than all the others combined. Choose columns, alias them, and learn why SELECT * belongs in the console and not in c...
SELECT
Selecting columns, aliases, expressions, DISTINCT, ORDER BY, LIMIT and pagination.
3 notes
Notes
SQL
Expressions, Calculated Columns and DISTINCT
Compute values in the select list, build derived columns from existing ones, and use DISTINCT correctly - including what it does across several column...
SQL
ORDER BY, LIMIT and Pagination
Sorting on one or many columns, NULL placement, and the four dialect specific ways to fetch page two of a result set - including why OFFSET gets slow.