Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
How to get Table row no/row index in sql-server.
on 11/24/2013 | Category:
Sql Server Interview questions
| Views: 1027 |
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';
Many Interviews |
< Previous :
How to get Row Index in MySQL?
Next > :
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
How many ways to compare String values in Dot Net?
In Gridview' RowEditing event, what piece of code should be writte ...
In Gridview' RowCancelingEdit event, what piece of code should be ...
Which Gridview event is used for Update operation?
Explain the various CommandName properties used in Gridview to perform ...
How to get Gridview Selected Row-Index?
Which CommandName property of Command Button,Link Button or Image Butt ...
Latest Interview Questions
In case we are returning anonymous type from Controller to the views, ...
Which of the following transaction isolation levels is the default in ...
Which of the following is FALSE regarding DML triggers?
If you have ON DELETE CASCADE statement to the foreign key relationshi ...
SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'study'), ...
Which is social features introduced in SharePoint 2010?
What is the difference between BDC and BCS?
How to limit the results to include only the top 100 most recent recor ...