oracle的between..and..前后都是闭区间,也就是说包含两个端的数,例如:
SELECT * FROM employees WHERE salary BETWEEN 2000 AND 3000;
查询返回 2000<=工资<=3000的员工
oracle的between..and..前后都是闭区间,也就是说包含两个端的数,例如:
SELECT * FROM employees WHERE salary BETWEEN 2000 AND 3000;
查询返回 2000<=工资<=3000的员工