使用NOT BETWEEN运算符:
SELECT * FROM table_name WHERE date_column NOT BETWEEN start_date AND end_date;
例如:
SELECT * FROM orders WHERE order_date NOT BETWEEN '2022-01-01' AND '2022-12-31';
使用NOT BETWEEN运算符:
SELECT * FROM table_name WHERE date_column NOT BETWEEN start_date AND end_date;
例如:
SELECT * FROM orders WHERE order_date NOT BETWEEN '2022-01-01' AND '2022-12-31';