SQL group by 后查某字段最大值答:修正下楼上的code:select ta.a,ta.tname,ta.sum_b from (select a,tname,sum(b) as sum_b from #Test group by a,tName ) ta,(select a,max(sum_b) max_b from (select a,tname,sum(b) as sum_b from #Test group by a,tName ) tb1 group by a ) tb where ta.a = ...
sql查询最大值及其id的方法答:SELECT b.ID, b.ab FROM (SELECT ID, ab, tt FROM aaaa UNION ALL SELECT ID, ab, tt FROM bbbb) b WHERE EXISTS (SELECT 1 FROM (SELECT a.tt, MAX (a.ab) ab FROM (SELECT ID, ab, tt FROM aaaa UNION ALL SELECT ID, ab, tt FROM bbbb) a GROUP BY a.tt) c WHERE ...