Define AND & OR conditions in SQL

The AND & OR is used to join two or more conditions in a WHERE clause

The AND operator displays a row if ALL the conditions listed are true.

Example :

Select * from Employees where EmployeeName = ‘Steve’ and City = ‘Bangalore’

This Query will display the each person with EmployeeName equal to “Steve” and City equal to

“Bangalore”

The OR operator displays a row if ANY of the conditions listed are true

Example :

Select * from Employees where EmployeeName = ‘Steve’ or City = ‘Bangalore’

This Query will display the each person with EmployeeName equal to “Steve” or City equal to

“Bangalore”.