SQL [AND OR] Operator

OBJECTIVE

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

 

 

example of and statemant

Example of OR statement

 

 

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.


Leave a Reply

Your email address will not be published. Required fields are marked *