SQL计数按数字序列分组
如果您的DBMS支持窗口功能(例如sql Server 2005+)
SELECT id, count(*) AS res FROM (SELECT *, [pNum] - ROW_NUMBER() OVER (PARTITION BY [id] ORDER BY [pNum]) AS Grp FROM YourTable) T GROUP BY id, Grp
SQL小提琴
你尚未登录,登录后可以
和开发者交流问题的细节
关注并接收问题和回答的更新提醒
参与内容的编辑和改进,让解决方法与时俱进
联系我
602392714
清零编程群