[LeetCode] Exchange Seats


   SELECT m.id
        , IFNULL(IF ( ( m.id & 0x1 ) = 1,r1.student, r2.student ),m.student) AS 'Student'
     FROM seat m
LEFT JOIN seat r1
       ON r1.id = (m.id+1)
LEFT JOIN seat r2
       ON r2.id = (m.id-1)
    ORDER BY id



Runtime: 166 ms, faster than 58.92% of MySQL online submissions for Exchange Seats.
------------------------------------------------------------------------


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



留言

張貼留言

這個網誌中的熱門文章

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. -------------------------------------------------------------------------------------------- 似乎不好，但簡單的寫法，歡迎大家流言討論，讓你我更好。
閱讀完整內容