SQL Logical operators

OBJECTIVE

In this chapter you will learn:

What is Logical operators?
Types of Logical operators
Example of Logical operators

 

What is Logical operators?

There are so many logical operators in which every operator has different types of work. Here all logical operators described with some examples.

 

Types of Logical operators

Logical Operator
ALL
AND
ANY
BETWEEN
EXISTS
IN
LIKE
NOT
OR
SOME
ISNULL
UNIQUE

 

Example

 

Output

logical operator example
 

Example Description

In the above example only those data retrieve from database which customer type is s and TerritoryId is 4 or 5. You can see the output in the figure.
SUMMARY

Here you have learned the logical operators and its type. An example of and , or logical operator is also given here with output. In the next chapter you will learn about String concatenation operator and its type.


Leave a Reply

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