Hi All,
I have one proble with sql server query.
i am creating the DLL file for the pagination on server side
i am writing this query from this i am getting count of the Table.now i want to get the data from table based on the row_number().please look int this query and correct it.
SELECT * FROM (SELECT page.*,PAGE_RANK, ROW_NUMBER() OVER (ORDER BY @@IDENTITY) AS PAGE_RANK FROM (SELECT * FROM (Select * from empcontacts) page ) pagenumber PAGE_RANK <= 1 AND PAGE_RANK >= 10,fro this i am getting pagrank syntax
Regards,
Narasimha
AartiPosted Dec 23, 2011, 5:13 AM
plz try with below code..
SELECT * FROM (SELECT pagenumber.*, ROW_NUMBER() OVER (ORDER BY @@IDENTITY)
AS PAGE_RANK FROM (SELECT * FROM (Select * from empcontacts) page ) pagenumber)a where
a. PAGE_RANK between 1 AND 10