SQL, Refreshed
Querying: SELECT, WHERE, ORDER, LIMIT
Lesson 2 of 5
A SELECT picks columns, filters rows, sorts them, then cuts the list — in that order.
What you'll learn
- Project columns and filter rows with SELECT and WHERE
- Sort results with ORDER BY and cap them with LIMIT
- Understand the logical order a query is evaluated in
Members only
A free account unlocks this lesson and every other one.
Runnable challenges, knowledge checks, and progress that syncs across your devices. No card needed.
Not sure yet? Try the free lesson first: Tables, types & constraints