摘要： employee: eid,ename,salary,deptid; select * from employee order by deptid desc,salary asc 阅读全文