How to get Table row no/row index in sql-server.

 Posted by vishalneeraj-24503 on 11/24/2013 | Category: Sql Server Interview questions | Views: 2415 | Points: 40
Answer:

With the help of Row_Number() sql-server in-built function, we can get table row number as below:-

select row_number() over(order by employee_id) as 'sr. no.'
from employee_mster where status='AA';


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response