求sql语句,求统计出来最大值。答:t3.b,t3.bbFROM (SELECT a,b,bbFROM (SELECT a,b,COUNT(b) AS bbFROM dbo.testGROUP BY a,b)t1) t3INNER JOIN (SELECT a,MAX(bb) ccFROM (SELECT a,b,COUNT(b) AS bbFROM dbo.testGROUP BY a,b) t1GROUP BY a) t2 ON t3.a=t2.a AND t3.bb=t2.ccORDER BY a结果:...