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”.