当前位置:Gxlcms >
数据库问题 >
Leetcode 180. Consecutive Numbers (Database)
Leetcode 180. Consecutive Numbers (Database)
时间:2021-07-01 10:21:17
帮助过:18人阅读
DISTINCT l1.Num
as ConsecutiveNums
from Logs l1, Logs l2, Logs l3
where l1.Id
=l2.Id
-1 and l2.Id
=l3.Id
-1
and l1.Num
=l2.Num
and l2.Num
=l3.Num
Leetcode 180. Consecutive Numbers (Database)
标签:tco ble 思路 ase -- nbsp find logs amp