;with cte as ( select rn=ROW_NUMBER() over(order by getdate())-1,* from base_entry_message ) select rn/5,* from cte
;WITH CTE AS( SELECT *,ROW_NUMBER()OVER(ORDER BY GETDATE())RN FROM TB ) SELECT *,(RN-1)/5+1 AS [GroupID] FROM CTE
34,837
社区成员
254,632
社区内容
加载中
试试用AI创作助手写篇文章吧