How do you combine conditions in WHERE?

SQL SELECT, filtering and sorting · Freshers

Model answer

Use AND, OR and NOT, with parentheses to control order, because AND binds tighter than OR. IN (1, 2, 3) tests a list, BETWEEN a AND b tests a range (inclusive), and LIKE with % and _ matches patterns.

Learn this topic

SELECT, FROM and WHERE: Your First Queries in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions