[SQL]betweenの否定のサンプル
書式
SELECT * FROM テーブル名
WHERE 列名 NOT BETWEEN 値1 AND 値2
使用例
SELECT
*
FROM
USER_TBL
WHERE
USERNO NOT BETWEEN 1002 AND 3003;
SELECT
*
FROM
USER_TBL
WHERE
USERNO NOT BETWEEN 1002 AND 3003;
SELECT * FROM USER_TBL WHERE USERNO NOT BETWEEN 1002 AND 3003;