SQL交叉200分(100)

wisdomphg · 2009-05-07

表Aaa bb cc dd ee ffds123 a 5 4 a1 a2 ds123 a 2 5ds234 b 3 4 b1 b2ds234 b 2 3 查出结果如下aa bb cc dd ee ffds123 a 7 9 a1 a2ds234 b 5 7 b1 b2

forgot2002 · 2009-05-07

Select aa,max(bb) as bb,sum(cc) as cc,sum(dd) as dd,max(ee) as ee,max(ff) as ff from Table1 group by aa

tianxing78 · 2009-05-07

这个太简单，已经解决了

李翔鹏 · 2009-05-07

一楼的方法应该可以。

znxia · 2009-05-07

Select aa,bb,sum(cc) as cc,sum(dd) as dd,max(ee) as ee,max(ff) as ff from Table1 group by aa, bb也是出现这个结果

de410 · 2009-05-07

1、4楼方法都可以~~