SQL如何对分组后的结果进行排序并且取前几名答:SQL取分组中的前几名 [sql] www.2cto.com create table #aa(class varchar(10),name varchar(10),lang int,math int)go insert into #aa select '1','a1',60,70 union all select '1','a2',80,70 union all select '1','a3',90,70 union all select '1','a4',50,70 go ...