Getting Row Serial Number

Posted by Rajesh_Kumar under Sql Server category on | Points: 40 | Views : 855
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;

Comments or Responses

Login to post response