Sql Sever query in SQL 2005

See more:

SQL-Server-2005

SQL-Server

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