Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Write a SELECT with a WHERE condition using comparison and logical operators.
- Sort results with ORDER BY, ascending or descending, on more than one column.
- Page through a large result using LIMIT and OFFSET.
- Read any basic SELECT statement and predict exactly what rows it returns, in what order.
Level 0 showed SELECT just enough to read earlier examples. This page goes properly deep on it. Nearly every later module needs confident filtering and sorting.