sqlserver分页查询

分类: 文章 • 2023-11-01 20:59:16

select * from ACT_RU_TASK order by CREATE_TIME_ desc

select top 5 * from ACT_RU_TASK
where ID_ not in(select top 10 ID_ from ACT_RU_TASK order by CREATE_TIME_ desc)
order by CREATE_TIME_ desc