SQL [AND OR] Operator Tutorial

In this chapter you will learn:
AND|OR statement
Syntax of AND|OR statement
Example of this statement

About AND|OR statement

SQL AND|OR statement is the supporting statement of select statement which is used to retrieve data with a condition. If you use AND then it is must to true to condition but if you use OR statement then any one of the condition is true then it can retrieve data.

Syntax of and|or statement

1. Select * from table_name where condition1 AND condition2
2. Select * from table_name where condition1 OR condition2

Example of AND statement

select * from humanresources.employee where title='Sales Representative' and MaritalStatus='S'

example of and statemant

Example of OR statement

select * from humanresources.employee where title='Sales Representative' or MaritalStatus='S'

example of or statemant
SUMMARY

In this chapter, you have learned about AND|OR statement of SQL Server. In the next chapter you will learn about order by statement.

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.