ORACLE中between and是包含两边边界的吗?
ID between A and B
类似于
A<= ID <= B
是的,包含边界。
(SYS@pdb1) [PDB1] 16:30:41> select * from t1 where a between 1 and 2; A ---------- 1 2 2 rows selected.