WHERE Clause - Filtering Rows1 / 10
In SQL, the WHERE clause lets you filter the results for rows which meet a certain criteria. Take a look at the planets table below. You want to return only the planets that are classified as Gas Giants. Try typing:
Notice that in SQL, text goes inside single quotes, while numbers do not.
SELECT * FROM planets WHERE type = 'Gas Giant';.Notice that in SQL, text goes inside single quotes, while numbers do not.
Ctrl+Enter to submit
WHERE Clause - Filtering Rows - Free SQL Practice Online
Practise WHERE Clause - Filtering Rows with 10 free, interactive SQL exercises. You type real queries into your browser and get instant feedback on every answer - no database setup, no install, and no signup. It is a fast, hands-on way to learn SQL online and build query skills you can use at work.