Operators in The WHERE Clause
The following operators can be used in the WHERE clause:
|
SR.NO |
Operator |
Description Example |
|
1 |
= |
Equal |
|
2 |
> |
Greater than |
|
3 |
< |
Less than |
|
4 |
>= |
Greater than or equal |
|
5 |
<= |
Less than or equal |
|
6 |
<> |
Not equal. Note: In some versions of SQL this operator may be written as != |
|
7 |
BETWEEN |
Between a certain range |
|
8 |
LIKE |
Search for a pattern |
|
9 |
IN |
To specify multiple possible values for a column |
1.Example Equal Operator (=) :
SELECT * FROM Products
WHERE Price = 18;
2.Example Greater than Operator (>) :
SELECT * FROM Products
WHERE Price > 30;
3.Example Less than Operator (<):
SELECT * FROM Products
WHERE Price < 30;
4.Example Greater than Equal Operator (>=) :
SELECT * FROM Products
WHERE Price >= 30;
5.Example Less than Equal Operator (<=) :
SELECT * FROM Products
WHERE Price <= 30;
6.Example Not equal Operator (<>) :
SELECT * FROM Products
WHERE Price <> 18;
7.Example BETWEEN Operator (BETWEEN) :
SELECT * FROM Products
WHERE Price BETWEEN 50 AND 60;
8. Example LIKE Operator (LIKE) :
SELECT * FROM Customers
WHERE City LIKE 's%';
9. Example IN Operator (IN) :
SELECT * FROM Customers
WHERE City IN ('Paris','London');