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:

Query:

SELECT “NAME”, “AGE”  
FROM “STUDENTS”  
WHERE “ID” BETWEEN 2 AND 6;

Output:

Please follow and like us: