Orcale SQL Tutorial
Loading...
Between
ORACLE BETWEEN
In Oracle, BETWEEN is used to get the values from given range in select, insert, delete or update statement
Syntax
- Expression BETWEEN value1 AND value2;
Parameters
Expression: column name
value1 and value2: values for range
Table:
Example 1
select id, name, age from table1 where age between 20 AND 28 |