Question

Display additional column with sequential numbers in sql server

Answer 1

Using ROW_NUMBER() (documentation)

SELECT ROW_NUMBER() OVER (ORDER BY EmpID ASC) AS No, EmpID, EmpName, Salary FROM Employee