小宝的家

数据： [code="java"]fuyou@ORCL> select ename||sal from emp; ENAME||SAL ------------------------------------------------------------ SMITH800 ALLEN1600 WARD1250 JONES2975 MARTIN1250 BLAKE2850 ...

例子： [code="java"] fuyou@ORCL> select deptno,ename,row_number() over(partition by deptno order by empno)rn 2 ,count(*)over(partition by deptno) cnt 3 from emp; DEPTNO ENAME ...