t-sql查询去重分页

 select * from (
                        select *, ROW_NUMBER() OVER( order by ID desc) as RowNumber from
                         (
                        select * from (
                        select *,ROW_NUMBER() over(PARTITION by StuKonwledgeID, StuNO order by ID desc)  times from yx_stuknowledge 
                        ) tb1 
                        where tb1.times=1 and 1=1) 
                        tb2 ) tb3 where tb3.RowNumber BETWEEN 41 and 60

利用row_number over(partition by ..)   times =1 来去重

row_number over(order by ..) between  and 来分页