🔍
Beginner About 20 min
SELECT, WHERE & ORDER BY
The foundation of every SQL query — pick columns, filter rows, sort, and limit results.
What you'll learn
- Write SELECT statements to pick specific columns from a table
- Filter rows with WHERE using comparison operators and logical connectors
- Sort results with ORDER BY in ascending and descending order
- Limit output with LIMIT and OFFSET for pagination
- Use column aliases to rename output columns