What is AND, OR and NOT Operators in SQL

AND, OR, and NOT operators are combined with the WHERE clause to get the desired filtered results.

 

e.g SELECT * FROM Users

WHERE State =’illinois’ AND City=’Chicago’;

 

e.g SELECT * FROM Users

WHERE City=’Chicago’ OR City=’New York’;

 

e.g SELECT * FROM Users

WHERE NOT State =’Chicago’;

fb-share-icon