
題目鏈接:
解析:
這道題比較簡單,就是將表應用三次,直接使用WHERE限定即可,值的注意的是需要使用DISTINCT來進行去重。
題解:
# Write your MySQL query statement below
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;