AndroidApacheAutomation FrameworkAutomation/QTP/Selenium BlogsGoogle adsenseJava, JavaScriptquestionsSQLTechnical blogTrending

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’;