请问如何取读出来的数据后10条

[wdxgdiy]

select top 20 sender,sum(points) as num from liwu where sendtime between @t and @e group by(sender) order by num desc

比如这条语句能读出来20条数据。我想取11~20 这10条数据应该如何操作或者如何写新的语句呢？

[Sharon_liu]

SELECT TOP 10 * FROM (
select top 20 sender,sum(points) 'POINTS',NUM as num from liwu where sendtime between @t and @e group by(sender) order by num desc
) ORDER BY NUM ASC

[jiangshun]

select top 10 * from (select top 20 sender,sum(points) as num from liwu where sendtime between @t and @e group by(sender) order by num desc)g order by num 

[nightmaple]

select top 10 * from
(select top 20 sender,sum(points) as num from liwu 
where sendtime between @t and @e group by(sender) order by num) tb
order by num desc

[Sharon_liu]

写错了，用这个

SELECT  * FROM (
select ROW_NUMBER() OVER (ORDER BY NUM DESC) 'ID',sender,sum(points) 'POINTS' as num from liwu where sendtime between @t and @e group by(sender)
) T WHERE ID BETWEEN 11 AND 20

[dawugui]

select top 10 * from 
(
select top 20 sender,sum(points) as num from liwu where sendtime between @t and @e group by(sender) order by num desc
) t
order by num

[Sharon_liu]

[Quote=引用 5 楼 dawugui 的回复:]

SQL code
select top 10 * from
(
select top 20 sender,sum(points) as num from liwu where sendtime between @t and @e group by(sender) order by num desc
) t
order by num
[/Quote]
他这个需求可能不能这么做，里面作为排序的num并没有输出，所以第11到20位的num无法通过sum(points)确定

[老黎]

select top 10 from 
(
select top 20 sender,sum(points) as num from liwu where sendtime between @t and @e group by(sender) order by num desc
) a
order by num