SELECT deptno,ename,empno,
ROW_NUMBER() OVER(partition by deptno ORDER BY empno) AS emp_id
FROM emp;
SELECT deptno,ename,empno,
ROW_NUMBER() OVER(partition by deptno ORDER BY empno) AS emp_id
FROM emp;
转载于:https://www.cnblogs.com/21heshang/p/6479401.html