Leetcode 603. 连续空余座位

(求连续的几个序号都可以用lag和lead这种套路，新增列然后判断）

代码语言：javascript复制

select seat_id from
    (select * ,lag(free,1) over(order by seat_id) l1,head(free,1) order(order by seat_id) l2 
    from cinema) A
    where free=1
    and (l1=1 or l2=1)

lag

0 人点赞