|
BETWEEN
BETWEEN is a range condition used in SQL Statements.Obtain tuples from a table which are in the given range condition.
Syntax ::
SELECT * FROM <TABLE>
WHERE <COLUMN> BETWEEN <RANGE1> AND <RANGE2>
Example ::
SELECT * FROM CUSTOMER
WHERE CUST_SAL BETWEEN 20000 AND 30000;
|
|
|
