Paged results – sql server

Posted: May 26, 2017 in SQLServer, Uncategorized
Tags: , , ,
;with a(
rcontrolid,logoname
)as (
select top 20 RControlId,LogoName  from RControl),
b(
RowNumber,rcontrolid ,logoname
)AS ( SELECT ROW_NUMBER () OVER (ORDER BY RControlId ASC ) AS RowNumber,* FROM a)
select * from b where RowNumber between 2 and 6

Leave a comment