Question

怎样查出数据库里第10 条 到第20条数据

我给定两个数字 假如是 11 和 20 怎样查出这之间的10条数据

Answer 1

--SQL2000
declare @id_begin int,@id_end int,@sql varchar(8000)
set @id_begin = 11
set @id_end = 20
set @sql = 'select top '+cast((@id_end - @id_begin +1) as varchar(20))+' * from (select top '+cast(@id_end as varchar(20))+' * from 表 order by 排序字段) tb order by 排序字段 desc'
exec(@sql)

--sql2005
declare @id_begin int,@id_end int,@sql varchar(8000)
set @id_begin = 11
set @id_end = 20

select top(@id_end - @id_begin +1) * from (select top (@id_end) * from 表 order by 排序字段) tb order by 排序字段 desc