4个人一起去看电影,准备预订电影票横向坐一起，从这么多排座位中，找出连续4个空位的全部组合，结果输出座位组合情况，如下
(1~4 6~9)
WITH ABC AS
(
SELECT
seat,status,rowid
,ROW_NUMBER()OVER(PARTITION BY rowid ORDER BY seat ASC) - seat AS RN
FROM 你的表
WHERE status = '未预定'
)
SELECT SEAT FROM ABC A
JOIN
SELECT RN,ROWID,COUNT(ROWID) AS NUMS
FROM ABC GROUP BY RN,ROWID HAVING COUNT(ROWID) >= 4
) B ON A.ROWID = B.ROWID AND A.RN = B.RN
ORDER BY SEAT
1min目标场景问卷
立即参与
