「Oracle」betweenで条件を指定する方法
1.betweenで条件を指定
使用例
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で条件指定
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;