Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

ROW_NUMBER() Function - SQL Server

Example¶

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

Notes¶

• ROW_ID in Oracle = ROW_NUMBER() in SQL Server