employee: eid,ename,salary,deptid; select * from employee order by deptid desc,salary asc 转载于:https://www.cnblogs.com/MessiAndDream/p/6404021.html