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