MODULE 1 · Reading data
Reading · 15 min
Filtering rows
Filtering rows
Filtering narrows a table to the rows that meet a condition. Express the condition clearly and test it with a small result set.
Learning objectives
- Filter with WHERE
- Combine conditions with AND
Use WHERE to limit results to the records that matter. Focus on explaining each decision in your own words before relying on a pattern or shortcut.
Example
SELECT name, total
FROM orders
WHERE total >= 100 AND status = 'paid';Summary
KEY TAKEAWAYS
- WHERE filters rows before they are returned.
- Use explicit conditions that match the data type.
Reading material
Filtering rows practice prompt
Use the exercise in this lesson to check your understanding.
Your progress is saved on this device. Sign in to keep it across devices.