P Narasimha

P Narasimha

  • 720
  • 1.3k
  • 247.2k

Sql server 2005/2008 query problem

Dec 23 2011 3:48 AM


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


Answers (1)