BETWEEN AND的范围

BETWEEN AND的范围是大于等于“取值1”,同时小于等于“取值2”。 例1:

1
SELECT * FROM employee WHERE age BETWEEN 18 AND 24;

age字段的取值是大于等于18,并且小于等于24。

例2:

[阅读全文]