Getting Row Serial Number

With Row_Number() in-built Sql Server function,we can get Row Serial Number.It is useful when we are dealing with custom paging in Gridview.

Select Row_Number() Over(order by requisition_id) as 'Row Serial Number', * from requisition_master;