Signup/Sign In

SQL AND & OR operator

The AND and OR operators are used with the WHERE clause to make more precise conditions for fetching data from database by combining more than one condition together.


AND operator

AND operator is used to set multiple conditions with the WHERE clause, alongside, SELECT, UPDATE or DELETE SQL queries.


Example of AND operator

Consider the following Emp table

eidnameagesalary
401Anu225000
402Shane298000
403Rohan3412000
404Scott4410000
405Tiger359000
SELECT * FROM Emp WHERE salary < 10000 AND age > 25

The above query will return records where salary is less than 10000 and age greater than 25. Hope you get the concept here. We have used the AND operator to specify two conditions with WHERE clause.

eidnameagesalary
402Shane298000
405Tiger359000

OR operator

OR operator is also used to combine multiple conditions with WHERE clause. The only difference between AND and OR is their behaviour.

When we use AND to combine two or more than two conditions, records satisfying all the specified conditions will be there in the result.

But in case of OR operator, atleast one condition from the conditions specified must be satisfied by any record to be in the resultset.


Example of OR operator

Consider the following Emp table

eidnameagesalary
401Anu225000
402Shane298000
403Rohan3412000
404Scott4410000
405Tiger359000
SELECT * FROM Emp WHERE salary > 10000 OR age > 25 

The above query will return records where either salary is greater than 10000 or age is greater than 25.

402Shane298000
403Rohan3412000
404Scott4410000
405Tiger359000