SELECT last_name,salary
FROM employees
WHERE salary NOTBETWEEN8000AND17000ORDERBY salary DESCLIMIT20,20;
3. 查询邮箱中包含 e 的员工信息,并先按邮箱的字节数降序,再按部门号升序
select last_name,email,department_id
from employees
where email like'%e%'orderby length(email)desc,department_id asc;
或
SELECT last_name,email,department_id
FROM employees
WHERE email REGEXP'[e]'ORDERBY LENGTH(email)DESC,department_id ASC;