SQL AND Operator

The SQL AND operator returns a TRUE only if all conditions are also TRUE.  The following truth table shows all combinations of values for the condition (A AND B). 

Notice that for the entire expression to be true, both A and B must be true.  We can use this to our favor when writing queries where one or more columns must match to be included in a result. 

This query returns every Person whose first name is John and with a PersonType of EM.

SELECT BusinessEntityId, PersonType, FirstName, LastName 
FROM   Person.Person 
WHERE  PersonType = 'EM' AND FirstName = 'John'

Additional  Resources 

To learn more about the AND Operator, check out these useful resources: 

• Query SQL Server Using Boolean Logic 
• Introduction to SQL Servers Built-In Logical Functions 
• Recommended book SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach