「Oracle」betweenで条件を指定する方法

2021年9月7日

1.betweenで条件を指定
使用例

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
*
FROM
USER_TBL
WHERE
AGE BETWEEN 20 AND 30
ORDER BY
USERNO;
SELECT * FROM USER_TBL WHERE AGE BETWEEN 20 AND 30 ORDER BY USERNO;
SELECT
  * 
FROM
  USER_TBL 
WHERE
  AGE BETWEEN 20 AND 30 
ORDER BY
  USERNO;

2.not betweenで条件指定

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
*
FROM
USER_TBL
WHERE
AGE NOT BETWEEN 20 AND 30
ORDER BY
USERNO;
SELECT * FROM USER_TBL WHERE AGE NOT BETWEEN 20 AND 30 ORDER BY USERNO;
SELECT
  * 
FROM
  USER_TBL 
WHERE
  AGE NOT BETWEEN 20 AND 30 
ORDER BY
  USERNO;

 

Oracle

Posted by arkgame