Efficient paging using SQL script

string Query = string.Format(@"SELECT * FROM (SELECT *, " + 
     @"ROW_NUMBER() OVER(ORDER BY PRODUCT_ID DESC ) AS ROW_NUM  FROM({0}) " + 
     @"AS TEMP_INNER) AS TEMP_OUTER  WHERE ROW_NUM BETWEEN '{1}' AND " + 
     @"({2} + {3}) - 1", strSql, startRowIndex, startRowIndex, maximumRows);

I am a professional Software Developer. I have experience in developing Windows Applications, e-commerce Portals, Content Management Systems and Data driven websites.
My technical forte includes: C#, ASP.NET, ADO.NET, JavaScript, jQuery, SQL Server, Design Patterns.
My interests involves programming, website development, developing applications for Android and learning subjects related to Software Engineering/Information Systems. Currently I am working as a Software Engineer at PowerObjects Pvt Ltd.