Provided here is a table containing the SQL logical operations with a brief description of each.
Operator
Description
=
Equal to
!= or <>
Not equal to
>
Greater than
>=
Greater than or equal to
<
Less than
<=
Less than or equal to
In
Equal to any item in a list
Not in
Not equal to any item in a list
Between
Between two values
Not between
Not between two values
Begins with
Begins with specified value
Contains
Contains specified value
Not contains
Does not contain specified value
Is null
Is blank
Is not null
Is not blank
Like
Like a specified pattern.
Not like
Not like a specified pattern.
.
No Comments