sql查询表中根据某列排序的任意行语句

<div class="codetitle"><a style="CURSOR: pointer" data="80300" class="copybut" id="copybut80300" onclick="doCopy('code80300')"> 代码如下:<div class="codebody" id="code80300">
select
from (select t.,
row_number() over(order by 列 desc) r
from 表 t)
where r <= 某行 and r>=某行