SQL WHERE Clause

The SQL WHERE clause is used to restrict the number of rows affected by a SELECT, UPDATE or DELETE query.

• WHERE clause is used to limit the number of rows.
• WHERE clause filters for rows that meet certain criteria.
• WHERE clause is followed by a condition that returns either true or false.

SQL WHERE syntax

The WHERE clause is not only used in SELECT statement, it is also used in UPDATE, DELETE etc.

Where clause with a SELECT

SELECT column_names
FROM table_name
WHERE [condition];

Where clause with a UPDATE

UPDATE table_name
SET column_name = value
WHERE [condition];

Where clause with a DELETE

DELETE table_name
WHERE [condition];

Employee Table

A sample of EMPLOYEE records table & the name of table Employee. The column(s) of the Employee table [ID, EMPLOYEE_NAME, EMPLOYEE_EMAIL, ADDRESS, CITY, and COUNTRY]:

SELECT Query, WHERE Clause Example

Note: For char value should be enclosed in quotes

SELECT * FROM Employee 
WHERE Country = 'India';

Result

WHERE Clause Operators