LXLogicExcel
🔥
0
0
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:

SELECT * FROM planets WHERE type = 'Gas Giant';.
Notice that in SQL, text goes inside single quotes, while numbers do not.

Ctrl+Enter to submit

🔥 0 streak
0 XP this lesson
All lessons