（求救）提出数据库中从第10条到第20条记录的SQL语句应该怎么写？

[tmluwei]

提出数据库中从第10条到第20条记录的SQL语句应该怎么写？

[OracleRoob]

select top 100 identity(int,1,1) as ID
into #t
from syscolumns c1 ,syscolumns c2

select * from #t

--从第10条到第20条记录
select top 10 *
from (select top 20 * from #t order by id ) t
order by id desc

drop table #t

[jaway]

楼上笔误
select top 11 *
from (select top 20 * from #t order by id ) t
order by id desc

[simonhehe]

select top 10 *
from (select top 20 * from Ytable) t
order by Ycol desc

[shazi_pig]

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

[student_oa]

我和楼上一样

[zwlwenlong]

我曾经写的
select top 10 * from (select top 20 * from test order by x1)m
where m.x1 not in(select top 10 x1 from test order by x1)