Sql Between In Notin — Free Sql Tutorial
Learn Sql Between In Notin in Sql with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.
TL;DR: Learn Sql Between In Notin 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 Between In Notin in Sql
BETWEEN x AND y is shorthand for >= x AND <= y (inclusive on both ends). Works with numbers, dates, text.
IN (val1, val2, val3) matches if column equals any value in the list. Faster than multiple ORs.
NOT IN (list) excludes rows where column matches any value. Beware: if list contains NULL, NOT IN returns no rows. Use NOT EXISTS instead.
Sql Between In Notin — Syntax
WHERE marks BETWEEN 70 AND 90
WHERE city IN ('Delhi', 'Mumbai', 'Bangalore')
WHERE status NOT IN ('inactive', 'deleted')
WHERE date BETWEEN '2025-01-01' AND '2025-12-31'
Learn Sql Between In Notin 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 →