题意:投影出连续三个num值相等的元组的num
题目链接:https://leetcode.com/problems/consecutive-numbers/
select distinct l1.num
from Logs as l1, Logs as l2, Logs as l3
where l1.Id + 1 = l2.Id and l1.Id + 2 = l3.Id and l1.Num = l2.Num and l1.Num = l3.Num;
题意:投影出连续三个num值相等的元组的num
题目链接:https://leetcode.com/problems/consecutive-numbers/
select distinct l1.num
from Logs as l1, Logs as l2, Logs as l3
where l1.Id + 1 = l2.Id and l1.Id + 2 = l3.Id and l1.Num = l2.Num and l1.Num = l3.Num;