Hi All,
I have one proble with sql server query.i am creating the DLL file for the pagination on server sidei 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