SQL WHERE Clause

WHERE Clause

Where clause used to filter data or records from database.

The WHERE clause is used to extract only those data or records, which fulfill a specified condition.
Syntax :

SELECT column1, column2,column3, . . . FROM table_name WHERE condition;

Example :

SELECT C_City FROM Customer01 WHERE C_Id = 1;

In above example, we are using equal sign.

The WHERE Clause Conditional selections used in the where clause are:

=	Equal
>	Greater than
<	Less than
>=	Greater than or equal
<=	Less than or equal
<>	Not equal to
Note: In some versions of SQL this operator may be written as !=
BETWEEN	Between a certain range
LIKE	Search for a pattern
IN TO	Specify multiple possible values for a column