The AND operator is a logical operator used to combine two or more conditions. For a row to satisfy an AND expression, all specified conditions must evaluate to TRUE.
Business requirements often contain multiple conditions that must be satisfied simultaneously. AND allows analysts to create precise filters using multiple rules.
A manager may want employees who work in Finance and earn more than ₹75,000. Both conditions must be true for the employee to appear in the result.
SELECT
EmployeeName,
Department,
Salary
FROM Employees
WHERE Department = 'Finance'
AND Salary > 75000;AND is commonly used in employee analysis, customer segmentation, transaction monitoring, compliance checks, financial reporting, and sales analysis.
- AND combines multiple conditions.
- All conditions must be TRUE.
- AND is commonly used with WHERE.
- AND can be combined with OR.
- Parentheses can clarify complex conditions.
What does AND do in SQL?
AND combines conditions and requires all specified conditions to be TRUE.
When would you use AND?
Use AND when multiple conditions must be satisfied at the same time.