Javatpoint Logo
Javatpoint Logo

PostgreSQL WHERE Clause

The WHERE clause specifies a condition while you fetch data from a table or a join of multiple tables. It is generally used with SELECT, UPDATE and DELETE statements to filter the results. It returns the specific result only when the condition is satisfied.

WHERE Clause with SELECT statement


Note: WHERE condition can be used with logical operators such as >, <, =, LIKE, NOT, OR, AND etc.


WHERE clause with single condition:

Let's take a table "EMPLOYEES" having the following data.

 postgresql where clause

Execute the following query to return a single record:


 postgresql where clause


WHERE clause with multiple conditions

We are using the same table "EMPLOYEES" for this example also.

Execute the following query:


 postgresql where clause

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA