how to get the rowid/rownumbes of a table in sqlserver
Answer Posted / vimal
SELECT ROW_NUMBER() OVER(ORDER BY eName ASC) AS Rno, *
FROM emp
asc or desc required
Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
How does index makes search faster?
How to provide values to user defined function parameters?
Do you know what are the differences between lost updates and uncommitted dependencies?
What is the difference between substr and charindex in the sql server?
What is the purpose of forms?
What is use of dbcc commands?
What are the aggregate and scalar functions?
What is tempdb database? : SQL Server Architecture
What are different types of replication in sql server?
When multiple after triggers are attached to sql table, how to control the order of execution?
What is a rollup clause?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Can we linked SharePoint to a SQL database?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
In what three ways is the return statement used in a stored procedure?