modified: MySQL/consecutive-numbers.sql

JinkeCao · JinkeCao · commit e9c31a00a64b · 2016-07-31T16:15:07.000+08:00
diff --git a/MySQL/consecutive-numbers.sql b/MySQL/consecutive-numbers.sql
@@ -29,7 +29,7 @@ FROM (
 ) sq
 WHERE how_many_cnt_in_a_row >= 3
 
-# Solution 1
+# Solution 2
 SELECT DISTINCT l1.Num  as ConsecutiveNums
 FROM Logs l1, Logs l2, Logs l3  
 WHERE l1.Id + 1 = l2.Id AND l2.Id + 1 = l3.Id AND l1.Num = l2.Num AND l2.Num = l3.Num 
