Select Records Based on Row Number in Sql Server-CodeGain

In this tips, i will explain how to select records based on Row number using ROW_NUMBER() function in sql server.It is a common issue of many of the guys on how we can fetch a record based on its record number.