between and

BETWEEN AND的范围是大于等于“取值1”，同时小于等于“取值2”。 例1： 1 SELECT * FROM employee WHERE age BETWEEN 18 AND 24; age字段的取值是大于等于18，并且小于等于24。 例 [阅读全文]