CodesJava

Easy learning with example program codes

BETWEEN condition in PostgreSQL

PostgreSQL BETWEEN
To filter the results, the PostgreSQL BETWEEN condition is used with SELECT, INSERT, UPDATE and DELETE statements to get values within a specific range from an expression.

Syntax:

WHERE expression BETWEEN value1 AND value2;    

Parameters:
expression: It is used to specify the column or field.
value1, value2: They are used to specify the range for the values.

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 “NAME”, “AGE”  
FROM “STUDENTS”  
WHERE “ID” BETWEEN 2 AND 6;

Output:

NAME	AGE
Smiley	13
Happy	11
Tom	15
Jerry	10
Bruno	6
Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status