ROW_NUMBER() OVER函数的基本用法用法

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

1	1021710	MARIAH	MANDEZ
2	2011111	ADAM	ACKERMAN
3	2021110	MICHAEL	POLAND
4	2021110	MICHAEL	POLAND
5	2021115	JIM	KENNEDY
6	2121000	JAMES	SMITH
7	3015670	MARTHA	LEDERER