--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
温馨提示:内容为网友见解,仅供参考