WHERE clauses

Use comparison operators, logical operators, and value operators in WHERE clauses.
Supported operators in WHERE clauses
Type
Operators
Comparison operators
<
,
<=
,
>
,
>=
,
=
,
<>
Logical operators
AND
,
OR
,
NOT
Value operators
IN
,
LIKE
,
BETWEEN
,
IS NULL

Supported functionality

Examples of supported WHERE functionality
Expected behavior
Query to achieve the expected behavior
Filter rows where Salary is greater than 60000.
SELECT * FROM TestTable1 WHERE Salary > 60000;
Filter rows where DepartmentID is NULL.
SELECT * FROM TestTable1 WHERE DepartmentID IS NULL;
Filter rows where DepartmentID is between 100 and 200.
SELECT * FROM TestTable1 WHERE DepartmentID BETWEEN 100 AND 200;

Unsupported functionality

  • Subqueries with dynamic references in WHERE clauses.
  • Aggregates in WHERE clauses.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal