Buy Questpond's video subscriptions on
huge discount
.
Online: 1368
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
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: 2354 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
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
Bookmark It
< Previous :
How to get Row Index in MySQL?
Next > :
How to get Gridview Row count from Javascript?
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
How to get Gridview Row count from Javascript?
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 ...
More ...