Between SQL operator
SELECT CASE WHEN 1 BETWEEN 1 AND 1 THEN '1 is between 1 and 1' ELSE '1 is not between 1 and 1' END as "Is 1 between 1 and 1 ?" FROM dual;
Is 1 between 1 and 1 ? ------------------------ 1 is between 1 and 1