sql数据库分页

[yy19890729]

select top 10 * from news order by id desc union select top 20 * from news order by id desc
我想取第十条至20条记录，我知道可以先去20条，倒序之后再取前十条，该怎么写呢


select top 10 * from news where id not in (select top 10 id from news order by id desc) order by id desc
这条语句可以实现。我想知道上面那种该怎么写

[ksaponka_tang]

with t
as
(
select row_number() over(order by ItemId) as row , * from InventTable
)

select * from t where t.row>=10 and t.row<=20

[永生天地]

select top 10 *
from (select top 20 * from news order by id ) t
order by id desc

[s_111111]

[Quote=引用 1 楼 xys_777 的回复:]
select top 10 *
from (select top 20 * from news order by id ) t
order by id desc
[/Quote]
up

[一朝春尽红颜老]

敢问lz"我想取第十条至20条记录??" 是11条数据?

select * from (
select row_number()over(order by id) as row,* from news
) a
where a.row>=10 and a.row<=20

[kuxuan21]

select top 10 * from news
where id not in
(select top 10 id from news)