how to get the rowid/rownumbes of a table in sqlserver
Answer Posted / dhivakar
SELECT
ROW_NUMBER() OVER (ORDER BY emp_id) AS rowid,
*
FROM employee
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is it ok to shrink transaction log?
Tell me what is difference between view and materialized view?
What are the functions in sql server?
What is data source object?
What is primary key, unique key, and foreign key?
How to return the date part only from a sql server datetime datatype?
How does stuff differ from the replace function?
Why would you use sql agent?
Do you know query execution plan?
difference between Clustered index and non clustered index ?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
How to provide login information for a new odbc dsn?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What is a subquery in a select query statement in ms sql server?
Find first and last day of current month in sql server