2011 年 CSDN 专家分前 20 名【非官方】解决方案

select top 20 r,sum(f)f from csdnscore group by r order by 2 desc/*r                              f------------------------------ -----------wxr0323                        214185wuyq11                         151890VisualEleven                   107041fredrickhu                     101404bdmh                           91736net_lover                      88070ACMAIN_CHM                     85027qianjin036a                    76530ssp2009                        73795AcHerat                        71042caozhy                         69432fangxinggood                   59686dawugui                        59479q107770540                     54417dizuo                          52126Sandy945                       51013maco_wang                      49242sp1234                         47290zhao4zhong1                    46890oyljerry                       46035(20 行受影响)*/