Auto Number in SQL

If you want to generate Sr. No in your results query, use below query.

SELECT ROW_NUMBER() OVER (ORDER BY EMPID ASC) AS ROWID, * FROM EMPLOYEE