|
复制SELECT ROW_NUMBER() OVER(ORDER BY score DESC,详解 pctfilledevals DESC, numsessions DESC, speaker) AS rownum, speaker, track, score, pctfilledevals, numsessions FROM SpeakerStats rownum speaker trackscore pctfilledevals numsessions ------ ---------- ---------- ----------- -------------- ----------- 1 Ron Dev 9 30 3 2 Suzanne DB 9 30 3 3 JessicaDev 9 19 1 4 Michele Sys 8 31 4 5 Kathy Sys 8 27 2 6 Mike DB 8 20 3 7 Kevin DB 7 25 4 8 Brian Sys 7 22 3 9 RobertDev 6 28 2 10 Joe Dev 6 20 2 11 Dan Sys 3 22 4 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19. 
|
喜欢
讨厌