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
what exactly sql injuction.how to overcome.....
How to replace given values with null using nullif()?
Can group by and orderby be used together?
List all the types of user-defined functions?
How to create a dml trigger using create trigger statements?
how would you troubleshoot blocking? : Sql server database administration
What is the exact numeric data type in sql?
What is a database in ms sql server?
How would we use distinct statement? What is its use?
What will be the maximum number of indexes per table?
What are commonly used odbc functions in php?
What is an etl file?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
How to execute a sql statement using odbc_exec()?