Oracle Databse - SQL - between

About

Between SQL operator

Articles Related

Is 1 between 1 and 1 ?

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