In Oracle, BETWEEN is used to get the values from given range in select, insert, delete or update statement
Expression BETWEEN value1 AND value2;
Expression: column name
value1 and value2: values for range
select id, name, age from table1 where age between 20 AND 28
