Beginner

172. AND Operator

Learn how the AND operator combines multiple conditions in SQL.

📘 Lesson 172 of 728 ⏱ 8 min 🎯 Beginner

The AND operator combines two or more conditions and returns TRUE only when all specified conditions are satisfied.

Business filters often require multiple conditions to be satisfied at the same time.

Find employees who belong to IT and earn more than ₹60,000.

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

AND is widely used in employee analysis, customer segmentation, transaction monitoring, compliance checks, and reporting.

  • AND combines multiple conditions.
  • All conditions must be TRUE.
  • It can be used with WHERE.
  • Multiple AND conditions can be combined.
  • Parentheses can improve clarity in complex logic.
What does AND do in SQL?

AND returns TRUE only when all connected conditions are satisfied.

Can SQL use more than two AND conditions?

Yes. Multiple conditions can be connected using AND.

Have you finished this lesson?

Introduction to SQL – All Lessons