查询每个部门给员工发的最高工资值

select * from mhxy, (select max(id) as id from mhxy group by name ) t where t.id = mhxy.id order by name