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 to provide values to user defined function parameters?
What is query and its types?
What is molap and its advantage? : sql server analysis services, ssas
What is the New in SQL server 2008?
What it means to be triggered?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
How to create a trigger for insert only?
Explain the commands in sql server?
What is cached report?
What is onf in normalization form?
Explain differences between web edition and business edition?
Write the syntax for stuff function in an sql server?
Explain what are the database objects? : SQL Server Architecture
what are the different types of replication you can set up in sql server? : Sql server database administration
How to get a list of columns using the "sp_help" stored procedure in ms sql server?