level 6
风风小旋
楼主
首先，大爱刀妹的无限飞刀。
另外，WINDOW你昨天晚上那个SQL我问了下同事调了下，可以出来了
select tt.recyear,yy.team,tt.sumteam from
(select aa.recyear,MAX(sumteam) as sumteam from
(select recyear,team,SUM(field1+field2) as sumteam from table_1 bb group by recyear,team) aa group by aa.recyear) tt
inner join
(select recyear,team,SUM(field1+field2) as sumteam from table_1 bb group by recyear,team) yy
on yy.recyear = tt.recyear and yy.sumteam = tt.sumteam
你同学看了就知道什么回事了，里面有些是用我们自己命名的表和参数,替换了就可以了
2012年04月16日 02点04分
1
另外，WINDOW你昨天晚上那个SQL我问了下同事调了下，可以出来了
select tt.recyear,yy.team,tt.sumteam from
(select aa.recyear,MAX(sumteam) as sumteam from
(select recyear,team,SUM(field1+field2) as sumteam from table_1 bb group by recyear,team) aa group by aa.recyear) tt
inner join
(select recyear,team,SUM(field1+field2) as sumteam from table_1 bb group by recyear,team) yy
on yy.recyear = tt.recyear and yy.sumteam = tt.sumteam
你同学看了就知道什么回事了，里面有些是用我们自己命名的表和参数,替换了就可以了
