SELECT with WHERE

Filter rows with a condition

Query

SQL

SELECT name, email FROM users WHERE age > 18;

What each clause does

SELECT name, email chooses specific columns. WHERE age > 18 filters rows to only those matching the condition.

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

SELECT All Rows INSERT INTO UPDATE SET DELETE FROM INNER JOIN LEFT JOIN GROUP BY ORDER BY Subquery CREATE TABLE Common Table Expression (CTE)Window Function UPSERT (ON CONFLICT)LIMIT & OFFSET