Where Clause :

In SQL where clause is used for filtering the records.
If condition mentioned in the where clause is satisfied by the record then and then that record will be selected.

SQL WHERE Syntax

SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;

Demo Example :

In this example we are using our customer database. Consider following “CUSTOMER” table -

Where Clause #1 : Select Customer living in Pune

Suppose we need to select all the customers that are living in Pune only then we can use below query -

SQL> Select * from CUSTOMER where city = 'Pune'

Above query will provide you following records

Where Clause #2 : Numeric Value

In the above example we have used single quote for specifying the value of the Column. In this example we will be using the numeric value as parameter in where clause.
Consider the below query -

SQL> Select * from CUSTOMER where ID = 3

Query will provide you following result -

Where Clause #3 : Operators and Conditions

The following operators can be used in the WHERE clause: