Thursday, March 17, 2011

Generating Row number

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

No comments:

Post a Comment