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 check if stored procedure is running in sql server?
What do you mean by stored techniques? How would we use it?
How do you migrate data from mssql server to azure?
What are the differences between char and varchar in ms sql server?
What is self contained multi valued query?
What is the difference between executequery () and executeupdate ()?
Explain the different types of joins?
What is database black box testing?
Tell me what is difference between view and materialized view?
What is dml command?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is executereader?
Which are the two editions in which SQL Azure database available?
can you implement data mining in SSRS?
Write query to return all rows sql?