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 |
