select * from (select *,row_id=row_number() over(order by 排序字段) from tb) t where row_id in(4,5,6)
select * from (select row_number() over(order by 排序列) rn,* from 你的表 )t where rn between 4 and 6;
--2 select top 3 * from (select top 6 * from tb order by 字段) t order by 字段 desc
select * from (select *,row_id=row_number() over(order by col) from tb) t where row_id in(4,5,6)--orselect top 3 * from (select top 6 * from tb order by col) t order by col desc
(select *,row_id=row_number() over(order by 排序字段) from tb) t
where row_id in(4,5,6)
select * from
(select row_number() over(order by 排序列) rn,*
from 你的表 )t
where rn between 4 and 6;
--2
select top 3 * from
(select top 6 * from tb order by 字段) t
order by 字段 desc
select * from
(select *,row_id=row_number() over(order by col) from tb) t
where row_id in(4,5,6)--orselect top 3 * from
(select top 6 * from tb order by col) t
order by col desc