- 提高简洁度
- between a and b 包含[a,b]
案例1:查询员工编号在100-120之间的员工信息
USE myemployees;
SELECT
*
FROM
employees
WHERE
# employee_id >=100 and employee_id <= 120;
employee_id BETWEEN 100 AND 120;
案例1:查询员工编号在100-120之间的员工信息
USE myemployees;
SELECT
*
FROM
employees
WHERE
# employee_id >=100 and employee_id <= 120;
employee_id BETWEEN 100 AND 120;