sql server递归分页查询

最新推荐文章于 2024-07-01 20:07:38 发布

风雪夜归人提示已存在

最新推荐文章于 2024-07-01 20:07:38 发布

阅读量735

点赞数

文章标签： sql server 递归分页

本文链接：https://blog.csdn.net/qq_38024577/article/details/78063911

版权

sql server递归分页查询

with temp
as
(
select b.UserID, b.SpreaderID,b.GameID
from QPAccountsDB.dbo.AccountsInfo b
where [SpreaderID] = 988
union all
select a.UserID, a.SpreaderID ,a.GameID
from QPAccountsDB.dbo.AccountsInfo a
inner join temp on a.[SpreaderID] = temp.[UserID]
)
select TOP 10 * from temp where SpreaderID not in
(
select top 0 SpreaderID from temp order by SpreaderID
)
order by SpreaderID