The WHERE clause is used to filter rows to specified condition(s).

Where can be used with SELECT, UPDATE, or DELETE .

SQL Where Clause Syntax:

SELECT  Column1

FROM Table_Name

WHERE condition;

Example:

Lets find all the products with the price above $1000 from the “Products” table.

Results:

SQL Tutorial