在PL/SQL客戶端,怎么代碼實(shí)現(xiàn) break on deptno skip 1
--break on deptno skip 2;
select distinct deptno,job,sum(sal)
from emp
group by rollup(deptno,job);
--break on deptno skip 2;
select distinct deptno,job,sum(sal)
from emp
group by rollup(deptno,job);
2018-06-07
舉報(bào)
2018-06-11
break on deptno skip 1