CodesJava

Easy learning with example program codes

AND condition in PostgreSQL

PostgreSQL AND
To filter the results, the PostgreSQL AND condition is used with SELECT, INSERT, UPDATE and DELETE statements to test more than one conditions.

Syntax:

WHERE condition_1
AND condition_2
AND condition_3
….
AND condition_n; 

Parameters:
condition_1, condition_2… condition_n: They are used to specify the conditions to be strictly followed for selection.

Example:
Students table:

ID	NAME	AGE
1	Joy	5
2	Smiley	13
3	Happy	11
4	Tom	15
5	Jerry	10
6	Bruno	6
7	David	8

Query:

SELECT *
FROM “STUDENTS”  
WHERE  “AGE” > 10  
AND  “AGE” < 15
ORDER BY “NAME”;

Output:

ID	NAME	AGE
3	Happy	11
2	Smiley	13
Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status