[이기적] SQL 활용

[white-gyu]

[white-gyu]

1. 4
2. 3
3. 2
4. 1

5. 3
6. 2
7. 2
8. 3
9. 1

• 스칼라 서브쿼리(Scala Subquery)

10. 4
11. lead(sal)

• oracle leg, lead 함수 사용법

select level, empno, ename, mgr
from emp
start with job = 'salesman'
connect by prior empno = mgr;

select b.name, a.job, sum(a.sal), sal, count(a.empno)
from emp a, dept b
where a.deptno = b.deptno
group by rollup(b.dname, a.job);