Display additional column with sequential numbers in sql server
Answers
Answered by
0
Using ROW_NUMBER() (documentation)
SELECT ROW_NUMBER() OVER (ORDER BY EmpID ASC) AS No, EmpID, EmpName, Salary FROM Employee
SELECT ROW_NUMBER() OVER (ORDER BY EmpID ASC) AS No, EmpID, EmpName, Salary FROM Employee
Similar questions
Math,
6 months ago
English,
6 months ago
Math,
6 months ago
Computer Science,
11 months ago
Business Studies,
11 months ago
History,
1 year ago