pl sql练习(4)
摘要:
1.ROW_NUMBER 返回连续的排位,不论值是否相等 1 select deptno,ename,sal, row_number () over (partition by deptno 2 order by sal desc) rn from emp; 3 4 10 KING 5000 1 5 10 CLARK 2450 2 6 10 MILLER 1300 3 7 20 SCOTT 5000 1 8 20 FORD 3000 2 9 20... 阅读全文
posted @ 2013-09-06 14:48 a_badegg 阅读(370) 评论(0) 推荐(0) 编辑