sqlbetween条件语句用法

SELECT columns
FROM tables
WHERE column1 between value1 and value2;

SELECT *
FROM suppliers
WHERE supplier_id between 5000 AND 5010;

SELECT *
FROM suppliers
WHERE supplier_id >= 5000
AND supplier_id <= 5010;

SELECT *
FROM orders
WHERE order_date between to_date ('2003/01/01', 'yyyy/mm/dd')
AND to_date ('2003/12/31', 'yyyy/mm/dd');

SELECT *
FROM orders
WHERE order_date >= to_date('2003/01/01', 'yyyy/mm/dd')
AND order_date <= to_date('2003/12/31','yyyy/mm/dd');

SELECT *
FROM suppliers
WHERE supplier_id not between 5000 and 5500;

SELECT *
FROM suppliers
WHERE supplier_id <5000
OR supplier_id > 5500;