数据库Between关键字 模糊查询

# 案例一

SELECT

            employees.employee_id

FROM

            employees

WHERE

            employees.employee_id >= 100 and employees.employee_id <= 120;

# 案例二

SELECT

            employees.employee_id

FROM

            employees

WHERE

            employees.employee_id BETWEEN 100 and 120;

# 两者等价