[LeetCode] Rank Scores


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.

 ------------------------------------------------------------------------


似乎不好，但簡單的寫法，歡迎大家流言討論，讓你我更好。

留言

張貼留言

這個網誌中的熱門文章

C# 在 GDI+ 中發生泛型錯誤

http://blog.miniasp.com/post/2009/05/A-generic-error-occurred-in-GDI-plus.aspx 解決: 1. http://stackoverflow.com/questions/15571022/how-to-find-reason-for-generic-gdi-error-when-saving-an-image (會造成 記憶體不足) ----------------------------------------------------------------------------------------------------- 2.使用暫存檔及壓縮jpg層級等級                      var tempFilePath = Path .Combine(strSavePath,rows + ".tmp" );                     file.SaveAs(tempFilePath);                     using ( var result = new Bitmap (tempFilePath))                     {             ...
閱讀完整內容

[LeetCode] Robot Return to Origin

  public class Solution {       public bool JudgeCircle( string moves)       {           var ms = moves.ToArray();           int Y = ms.Count(c => c == 'U' ) - ms.Count(c => c == 'D' );           int X = ms.Count(c => c == 'L' ) - ms.Count(c => c == 'R' );           return X == 0 && Y == 0;       } } Runtime:  108 ms , faster than  9.14%  of C# online submissions for Robot Return to Origin. Memory Usage:  25.8 MB , less than  5.55%  of C# online submissions for Robot Return to Origin. -------------------------------------------------------------------------------------------- 似乎不好，但簡單的寫法，歡迎大家流言討論，讓你我更好。
閱讀完整內容