SQL WHERE

In this tutorial, we will learn how to select a record based on a specific condition from the table using  SQL.

SQL WHERE Clause

SQL WHERE clause is used to filter records. WHERE clause is used to specify a condition while fetching/retrieving the records from a single table or by joining with multiple tables. If given condition satisfied, only then it returns a specific record or value from the table.

SELECT column1, column2....columnN 
FROM tableName
WHERE [CONDITION];

UPDATE tableName
SET column1=[new value1],column2=[new value2]....columnN=[new valueN]
WHERE [CONDITION];

DELETE FROM tableName
WHERE [CONDITION];

Example:

Let us consider this table "Employee" for records.

Table Name: Employee

Here are some examples of Where clause:

For finding an employee whose salary is greater than 25000,

SELECT * FROM Employee
WHERE Salary > 25000;

Multiple Conditions

You can Filter Records based on multiple Condition using operators: AND and OR Operator

AND Operator: The AND operator filters the records only when both the first condition and second condition is satisfy.

For finding an employee whose City is "Delhi" and Country is "India"

SELECT * FROM Employee
WHERE City='Delhi' AND Country='India';

OR Operator: The OR operator filters the records when either the first condition or second condition is satisfied.

For finding an employee whose City is "Delhi" or Country is "India"

SELECT * FROM Employee
WHERE City='Delhi' OR Country='India';

Operators used with WHERE Clause

The following operators can be used in the WHERE clause: