1.between 语句

Posted on Edited on In

 

1. between 语句

between A and B: 包含两端的端点的值，[A, B]，A <= value <= B

1
2
SELECT * from t_user
where age between 10 and 20;

2. not between 语句

not between A and B: between A and B的取反，不包含两端的端点的值，(_, A) and (B, _)，value < A and B < value

1
2
SELECT * from t_user
where age not between 10 and 20;