■ はじめに

SQL の BETWEEN句 / NOT BETWEEN句を扱う

【１】BETWEEN句 / NOT BETWEEN句

FROM TO を絞る時に使用

【２】構文

-- BETWEEN句
SELECT [項目] FROM [テーブル名]
WHERE
[対象項目] BETWEEN 条件1 AND 条件2 /* ★ここ注目★ */

-- NOT BETWEEN句
SELECT [項目] FROM [テーブル名]
WHERE
[対象項目] NOT BETWEEN 条件1 AND 条件2

【３】サンプル

SELECT * FROM testTable
WHERE birthDate
 BETWEEN '2010-01-01' AND '2010-12-31';

参考資料

http://www.atmarkit.co.jp/fnetwork/rensai/sql01/sql1.html

関連記事

SQL ～ IN句 ～
https://dk521123.hatenablog.com/entry/2024/12/01/000000