SQL SELECT and WHERE: Read Only the Rows You Need

Learn SQL SELECT and WHERE clauses with simple filtering examples using equals, greater than, AND, OR and NOT.

SELECT chooses columns. WHERE chooses rows. Start with a small result set, then add conditions one at a time so you can see which rule changes the output.

Example

SELECT department, COUNT(*) AS student_count FROM students WHERE active = 1 GROUP BY department ORDER BY student_count DESC;

Try it yourself

1. Create a five-row table.
2. Change one clause.
3. Explain the result.

Back to SQL learning path