Operators in SQL

Operators are symbols that specify the type of calculation that the different expressions perform. According to their nature, we can divide them into:

• Arithmetic operators.
• Comparison operators.
• Logical operators.
• String Concatenation operators.

Although the operators are not exclusive to the use of the WHERE clause of a SELECT, in this section we will focus on the most used in it for filtering and applying the conditions of a query. However, the user has access to more information in the Microsoft documentation regarding operator types.

Comparison operators

Comparison operators test whether two expressions are the same. Among these comparators we can find:

Equality operator (=)

This condition will return the record(s) whose field value is equal to the condition we are looking for:

You can also filter by text string:

Greater than operator (>)

This operator will return the records whose table field value is greater than the value we are entering in the condition:

Greater than or equal operator (>=)

This operator will return the records whose table field value is greater than or equal to the value we are introducing in the condition:

Less than operator (<)

This operator will return the records whose table field value is less than the value we are introducing in the condition:

Less than or equal operator (<=)

This operator will return the records whose table field value is less than or equal to the value we are introducing in the condition:

Not equal to operator (<>)

This operator will return the records whose table field value is different to the value we are introducing in the condition:

This operator can also be written using the symbol:!=

Equal to NULL operator: IS NULL

This operator will return records whose table field value is NULL:

Logical operators

Test for the truth of some condition.

LIKE operator

This operator allows us to search for records taking into account all or only part of a string chain:

The LIKE operator also allows searching by the beginning of a string.

We can also search using the final character(s) of a string:

Conditional operator OR

This operator is used to validate several conditions If any of them is met, the SELECT will return the given record:

In this case, we observe that, although not all the records returned have a totalPrice greater than 2500, thus failing to fulfill said condition, the rest fulfill the respective condition on the dateOrder.

Conditional operator AND

This operator is used to validate several conditions All must be met for the SELECT to return the information:

IN operator

The IN operator allows you to filter a list of values to return the corresponding records:

BETWEEN operator

This operator will return records within a range of values.

Negation operator: NOT

This operator will return records that do not meet the specified conditions:

This run will return all the bank accounts in the Customers table.