WHERE clause in PostgreSQL

PostgreSQL WHERE The PostgreSQL WHERE clause is used with SELECT, INSERT, UPDATE and DELETE statements to return the result only when the condition is satisfied.

Syntax:

WHERE conditions; 

Example 1: Selecting specific fields from a table. Employment table:

Query:

SELECT *  
FROM “EMPLOYMENT”
WHERE  “RATE” > 60;

Output:

Example 2: Using WHERE clause with AND condition. Employment table:

Query:

SELECT *  
FROM “EMPLOYMENT”
WHERE  “RATE” > 60
AND “ID” < 4;

Output:

Example 3: Using WHERE clause with OR condition. Employment table:

Query:

SELECT *  
FROM “EMPLOYMENT”
WHERE  “RATE” > 60
OR “ID” < 4;

Output:

Example 4: Using WHERE clause with both AND and OR condition. Employment table:

Query:

SELECT *  
FROM “EMPLOYMENT”
WHERE  (“RATE” > 60 AND “STATE” = ‘C’)
OR “ID” > 4;

Output:

Please follow and like us: