使用分组聚合就可以了，select dept_id as 部门id,last_name+first_name as 名字,salary as 工资from s_empwhere id in(select id from s_empgroup by dept_idhaving salary=max(salary))呵呵，希望能有帮助，^_^
