Operators in The WHERE Clause
Operators in The WHERE Clause
The following operators can be used in the WHERE clause:Operator | Description |
---|---|
= | Equal |
<> | Not equal. Note: In some versions of SQL this operator may be written as != |
> | Greater than |
< | Less than |
>= | Greater than or equal |
<= | Less than or equal |
BETWEEN | Between an inclusive range |
LIKE | Search for a pattern |
IN | To specify multiple possible values for a column |
Ввійдіть щоб вподобати
Ввійдіть щоб прокоментувати