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