PLSQL中over(partition by .. order by ..)的使用
摘要:
SQL> select deptno,ename,sal 2 from emp 3 order by deptno; DEPTNO ENAME SAL ---------- ---------- ---------- 10 CLARK 2450 KING 5000 MIL... 阅读全文
posted @ 2008-08-19 13:51 山虎 阅读(4434) 评论(0) 推荐(0) 编辑