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

浙公网安备 33010602011771号