求真知

[azfailx]

我写了这个
sql="select top 3 * from zm_news where fid = 22 order by ord asc,id desc"
查询的是前三条记录

那么 我要查第4到第六条记录要怎么写？？
跪求大虾解谜！！

[Limpire]

select * from
(select rn=row_number()over(order by ord asc,id desc), * from zm_news) t
where rn between 4 and 6

[叶子]

;with maco as
(
select row_number() over (order by ord asc,id desc) as rid,
 * from zm_news where fid = 22 
)
select * from maco where rid between 4 and 6

[美到心痛]

 SELECT TOP (6-4+1) * FROM zm_news AS a WHERE Not Exists
 (Select * From (Select Top (4-1) * From TABLE order by ord asc,id desc ) b 
  Where b.ord=a.ord and b.id=a.id )
 Order by ord asc,id desc 

[勿勿]

select   * from (select *,rn=row_number()over(order by ord asc,id desc) zm_news where fid = 22  ) a  where rn  between 4 and 6

[dawugui]

[Quote=引用楼主 azfailx 的回复:]
我写了这个
sql="select top 3 * from zm_news where fid = 22 order by ord asc,id desc"
查询的是前三条记录

那么 我要查第4到第六条记录要怎么写？？
跪求大虾解谜！！
[/Quote]

select top 3 * from
(select top 6 * from zm_news where fid = 22 order by ord asc,id desc) t
order by ord,id

select top 3 * from
(select top 6 * from zm_news where fid = 22 order by ord asc,id desc) t
order by id,ord