Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
67 Points
57 Posts
Feb 01, 2012 10:57 AM|LINK
got my answer :-) using count(*) over()
SELECT * FROM (SELECT LOCATION.*,row_number() over (order by ID) rn, count(*) over() FROM LOCATION) RN WHERE rn BETWEEN 1 AND 10
pratikasthan...
Member
67 Points
57 Posts
Re: Get Total Count of record with pagging in Oracle
Feb 01, 2012 10:57 AM|LINK
got my answer :-) using count(*) over()
SELECT * FROM (SELECT LOCATION.*,row_number() over (order by ID) rn, count(*) over() FROM LOCATION) RN WHERE rn BETWEEN 1 AND 10