leetcode

Leetcode submissions
git clone git://git.laack.co/leetcode.git
Log | Files | Refs | README

consecutive-numbers1.sql (197B)

      1 --Better solution that uses joins
      2 SELECT DISTINCT a.num ConsecutiveNums
      3 FROM Logs AS a
      4 LEFT JOIN Logs b
      5 ON a.id + 1 = b.id
      6 LEFT JOIN Logs c
      7 ON b.id + 1 = c.id
      8 WHERE a.num = b.num AND b.num = c.num