Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Ordering

Select all columns from the penguins table, ordered by bill_length_mm (ascending):

SELECT *
FROM penguins
ORDER BY bill_length_mm;

Select all columns from the penguins table, ordered by bill_length_mm (descending):

SELECT *
FROM penguins
ORDER BY bill_length_mm DESC;

Select all columns from the penguins table, ordered by species then bill_length_mm:

SELECT *
FROM penguins
ORDER BY species, bill_length_mm;