同一属性范围内比较可以使用between
/*获取points介于1000和3000之间的顾客*/
SELECT *
FROM customers
WHERE points >= 1000 AND points <= 3000
/*同一属性范围内比较可以使用between,上述代码简化为下面的*/
SELECT *
FROM customers
WHERE points BETWEEN 1000 AND 3000#范围值包含临界值,是一个闭区间
同一属性范围内比较可以使用between
/*获取points介于1000和3000之间的顾客*/
SELECT *
FROM customers
WHERE points >= 1000 AND points <= 3000
/*同一属性范围内比较可以使用between,上述代码简化为下面的*/
SELECT *
FROM customers
WHERE points BETWEEN 1000 AND 3000#范围值包含临界值,是一个闭区间