SELECT m . Score , Rank FROM Scores m JOIN ( SELECT Score AS 'Score' , ROW_NUMBER () OVER ( ORDER BY Score DESC ) AS RANK FROM ( SELECT DISTINCT Score from Scores ) r ) r1 ON m . Score = r1 . Score ORDER BY r1 . Rank Runtime : 1348 ms , faster than 26.61% of MS SQL Server online submissions for Rank Scores. ------------------------------------------------------------------------ 似乎不好,但簡單的寫法,歡迎大家流言討論,讓你我更好。
留言
張貼留言