Oracle Databse - SQL - between

Card Puncher Data Processing

About

Between SQL operator

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







Share this page:
Follow us:
Task Runner