First queries · Filter with WHERE
Ask for less
WHERE keeps the rows that match a condition and drops the rest. Text goes in single quotes; numbers don't.
Comparisons you can use: =, <> (not equal), <, >, <=, >=.
Go deeper: SQL WHERE: filtering rows
Try it
SELECT name, age FROM pets WHERE species = 'dog';
Press Enter to continue