SQL Logical Operators (And, Or, Like, In, Between, Exists, Not, ALL, Any)

Here we will learn what are the logical operators in SQL server and how to use logical operators in SQL select statements or queries with examples.

SQL Logical Operators

In SQL, logical operators are useful to perform some conditional and comparison checks in SQL statements. In logical operators, we have different types of operators available. Those are 

 

For more information related to logical operators in the SQL server, check the following information.

 

OperatorDescription
AND The AND operator in SQL is used to compare data with more than one condition. If all the conditions return TRUE, then only it will display records.
OR The OR operator in SQL compares data with more than one condition. If either of the condition is TRUE, it will return data.
ALL The ALL operator in SQL returns true when the value matches all values in a single column. It’s like AND operator; it will compare the value against all values in a column.
ANY The Any operator in SQL returns true when the value matches any value in a single column set of values. It’s like an OR operator, and it will compare the value against any value in the column.
LIKE The LIKE operator in SQL searches for a character string with the specified pattern using wildcards in a column.
IN The IN operator in SQL is used to search for a specified value that matches any value in the set of multiple values.
BETWEEN The BETWEEN operator in SQL is used to get values within a range.
EXISTS The EXISTS operator in SQL is used to show the result if the subquery returns data.
NOT The NOT operator in SQL is a negate operator, which means it will show data for the opposite of conditions that we mentioned in the SQL statement.
SOME The SOME operator in SQL compares values with a single column set of values returned by the subquery. SOME must match at least one value in a subquery, and that value must be preceded by comparison operators.