top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How we can develop database paging using PLSQL in Sql Server 2005?

0 votes
48 views
How we can develop database paging using PLSQL in Sql Server 2005?
posted Mar 17, 2016 by Latha

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes
DECLARE @StartRow INT

DECLARE @EndRow INT

SET @StartRow = 120

SET @EndRow = 140

SELECT Col1, Col2, Col3

FROM

(

SELECT A.Col1, A.Col2, A.Col3,

ROW_NUMBER() OVER(Order BY A.Col1, A.Col2, A.Col3) AS RowNumber

FROM tblTest A

) Test

WHERE RowNumber > @StartRow AND RowNumber < @EndRow

ORDER BY Col1, Col2, Col3
answer Mar 17, 2016 by Shivaranjini
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...