sqlserver查询某条到某条,1000条后的语句(流程)

select top 1000 id from workflowbase where id in(select requestid from ufr7w6s41398626260795) and isdelete=0 order by id

select top 1000 id from workflowbase where id in(select requestid from ufr7w6s41398626260795) and isdelete=0
and id not in(select top 1000 id from workflowbase where id in(select requestid from ufr7w6s41398626260795) and isdelete=0 order by id)order by id

posted @ 2026-01-04 14:06  java璀璨小菜鸟  阅读(18)  评论(0)    收藏  举报