SQL • LESSON 07

IN and BETWEEN

Learn how to filter SQL results using IN and BETWEEN conditions.

🟡 Intermediate⏱ 2 Minutes⭐ 140 XP
🤔 THE QUESTION

How can we filter rows when a column can contain one of several possible values?

💡 WHAT IS IT?

The IN operator checks whether a value matches any value from a specified list.

🎯 WHAT IS IT USED FOR?

It makes queries cleaner when filtering for multiple known values, such as departments, cities, job roles, or statuses.

💻 EXAMPLE
SELECT *
FROM employees
WHERE department IN (
  'IT',
  'HR',
  'Finance'
);

Mission Brief

Practice filtering records using IN and BETWEEN.

Objectives

  • ✓ SELECT
  • ✓ FROM
  • ✓ WHERE
  • ✓ IN
  • ✓ BETWEEN
🚀 Start Mission