求语句优化

[wwfxgm]

SELECT
*
FROM
(
SELECT
*,
row_number() over(order by qty desc) as rn
FROM
Sales.OrderDetails
) A
where rn between 5 and 12 我想先对子查询取出小于等于12的数，外层就只要写大于等于5即可，不过语句写不出来我想的那样。求大神帮忙！谢谢

[卖水果的net]

select * from (
select top 12 row_number() over(order by name) rn ,id, name , crdate 
from sysobjects 
) x
where rn >= 5 

[卖水果的net]

PS：你用移动端把上述内容贴出来，也算是有耐心；

[wwfxgm]

求大神帮忙，总要有诚心的嘛，这样版主。