Sql Where — Free Sql Tutorial
Learn Sql Where in Sql with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.
TL;DR: Learn Sql Where in Sql with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.
Written & reviewed by the Syllab.in Academic Team (CBSE/NCERT subject experts) · Updated
Sql Where in Sql
The WHERE clause filters rows that match a condition. Only matching rows are returned. Without WHERE, SELECT returns ALL rows.
Comparison operators: = (equal), != or <> (not equal), > (greater than), < (less than), >= (greater or equal), <= (less or equal). Combine conditions with AND, OR, NOT.
Special operators: IN (matches any value in a list), BETWEEN x AND y (range), LIKE '%pattern%' (text search, % = any characters, _ = one character), IS NULL / IS NOT NULL.
Sql Where — Syntax
SELECT * FROM table
WHERE condition;
WHERE marks > 80
WHERE marks BETWEEN 70 AND 90
WHERE city IN ('Delhi', 'Mumbai')
WHERE name LIKE 'A%' -- starts with A
WHERE name LIKE '%ar%' -- contains 'ar'
Learn Sql Where step by step with Syllab's free interactive Sql tutorial — runnable code examples, practice exercises and instant AI feedback, all free with no signup. Explore the full Sql course →