Beginner

358. AND Operator

Learn how to require multiple conditions to be true at the same time.

📘 Lesson 358 of 728 ⏱ 9 min 🎯 Beginner

The AND logical operator returns true when all specified conditions are true.

Business questions often contain multiple requirements, such as department plus salary or region plus sales amount.

Find IT employees earning more than ₹50,000.

SQL 
SELECT
    EmployeeName,
    Department,
    Salary
FROM Employees
WHERE Department = 'IT'
AND Salary > 50000;

AND is widely used for precise filtering, compliance rules, customer segmentation, and business reporting.

  • AND combines conditions.
  • All conditions must be true.
  • It makes filtering more specific.
  • Multiple AND conditions can be combined.
  • Parentheses can improve clarity when mixed with OR.
What does AND do in SQL?

AND requires all connected conditions to evaluate as true.

What happens if one AND condition is false?

The combined condition becomes false for that row.

Have you finished this lesson?

Introduction to SQL – All Lessons