当前位置: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   

人气教程排行