WHERE

The WHERE clause helps you filter data in a table. Instead of getting everything, it shows only the rows that match a condition.

Syntax

SELECT column1, column2
FROM table_name
WHERE condition;

Example

  • Find students older than 21.
SELECT name
FROM students
WHERE age > 21;

Question number:

Up Next: Practice ORDER BY

Donate

About

Privacy Policy

Changelog