SELECT PNAME, MAX(SLA) FROM [PROF]GROUP PNAME
如果就这两列 可以用以上T-SQL
select pname,slafrom profwhere sla = (select max(sal) from prof);
