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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s