Logical Operators in SQL
Learn about logical operators in SQL, with examples.
We'll cover the following...
Logical operators
Logical operators are used to combine two or more conditions. A table containing the list of logical operators in SQL is given below:
List of Logical Operators
Operator | Meaning |
| Returns |
| Returns |
| Returns |
| Returns |
| Returns |
Note: Operators in SQL are not case-sensitive.
The AND
operator
The AND
operator is used to select rows based on multiple conditions. The AND
operator will return all the rows where all the conditions are met. An example of using the AND
operator in SQL is given ...