SQL Operators: List of Operators in SQL

SQL Operators: List of Operators in SQL

This table shows a list of operators available in SQL. This list uses standard ANSI SQL, so should be applicable to all databases that use that standard (Oracle, SQL Server, MySQL, etc). We’ll look at all of these operators in this guide in more detail.

Operator	Meaning
=	Is equal to
!=	Is not equal to
<>	Is not equal to
>	Is greater than
>=	Is greater than or equal to
<	Is less than
<=	Is less than or equal to
IN	Is in a list of values
NOT IN	Is not in a list of values
EXISTS	Is found in a result set
NOT EXISTS	Is not found in a result set
LIKE	Is a partial match
NOT LIKE	Is not a partial match
BETWEEN	Is between two values
NOT BETWEEN	Is not between two values
ANY	Matches at least one of a list of values
ALL	Matches all of a list of values

Let’s take a look at these operators.