Logo 
Search:

SQL Server Articles

Submit Article
Home » Articles » SQL Server » Operator RSS Feeds

Logical Operators

Posted By: Sarita Patel     Category: SQL Server     Views: 2399

This article explains different logical operators available in SQL server with example.

Logical operators are used to evaluate some set of conditions. It returns boolean data type with a value of TRUE or FALSE.
 

Different Logical Operators : 

Operator

Meaning

ALL

TRUE if all of a set of comparisons are TRUE.

AND

TRUE if both Boolean expressions are TRUE.

ANY

TRUE if any one of a set of comparisons are TRUE.

BETWEEN

TRUE if the operand is within a range.

EXISTS

TRUEif a subquery contains any rows.

IN

TRUE if the operand is equal to one of a list of expressions.

LIKE

TRUE if the operand matches a pattern.

NOT

Reverses the value of any other Boolean operator.

OR

TRUE if either Boolean expression is TRUE.

SOME

TRUE if some of a set of comparisons are TRUE.

  
Share: 


Didn't find what you were looking for? Find more on Logical Operators Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of Logical Operators is from United States.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!