oracle sql
iteye_7135
这个作者很懒,什么都没留下…
展开
-
translate replace区别
数据:[code="java"]fuyou@ORCL> select ename||sal from emp;ENAME||SAL------------------------------------------------------------SMITH800ALLEN1600WARD1250JONES2975MARTIN1250BLAKE2850...原创 2010-08-06 23:48:23 · 121 阅读 · 0 评论 -
connect by
例子:[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 ...原创 2010-08-07 00:21:39 · 117 阅读 · 0 评论