WHERE
Try it yourself →Retrieves rows that match the condition.
Syntax
SELECT ... WHERE condition;
Description
Write conditions using = != < > <= >= operators and AND/OR.
Example
CREATE TABLE k(name TEXT, age INTEGER);
INSERT INTO k VALUES ('Alex', 36), ('Sam', 20);
SELECT name FROM k WHERE age >= 30;Expected output
Alex
When to use?
Fetching specific records.