between..and操作符 select * from employee where salary between 3000 and 10000; 查询 工资 范围包在3000 到10000的员工信息 。包含3000和10000这两个临界值