Lesson 02 · 10 min
WHERE, ORDER BY, LIMIT
Filter, sort, take the first page.
WHERE keeps only rows matching a condition: =, <>, >, IN (…), LIKE, IS NULL. ORDER BY sorts, DESC reverses. LIMIT and OFFSET take part of the result; that's how pages work.
Sign in to continue
The rest of this lesson opens after sign up
The first lesson of every course is open without an account. To read on, solve the practice and use Ask, create a free account or log in.