oracle 組函數

標籤：gif   png   報表   div   group by   select   --   acl   images   

 

 

 

group by的增強SQL> select deptno,job,sum(sal) from emp group by deptno,jobSQL> +SQL> select deptno,sum(sal) from emp group by deptnoSQL> +SQL> select sum(sal) from empSQL> SQL> ===SQL> SQL> select deptno,job,sum(sal) from emp group by rollup(deptno,job);SQL> SQL> 抽象SQL> group by rollup(a,b)SQL> ==SQL> group by a,bSQL> +SQL> group by aSQL> +SQL> group by nullSQL> SQL> */SQL> select deptno,job,sum(sal) from emp group by rollup(deptno,job);

 

 

報表

break on deptno skip 2SQL> /    DEPTNO JOB         SUM(SAL)                                                                                                                                                                         ---------- --------- ----------                                                                                                                                                                                 10 CLERK           1300                                                                                                                                                                                    MANAGER         2450                                                                                                                                                                                    PRESIDENT       5000                                                                                                                                                                                                    8750                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 20 CLERK           1900                                                                                                                                                                                    ANALYST         6000                                                                                                                                                                                    MANAGER         2975                                                                                                                                                                                                   10875                                                                                                                                                                                                                                                                                                                                                                                     DEPTNO JOB         SUM(SAL)                                                                                                                                                                         ---------- --------- ----------                                                                                                                                                                                                                                                                                                                                                                                         30 CLERK            950                                                                                                                                                                                    MANAGER         2850                                                                                                                                                                                    SALESMAN        5600                                                                                                                                                                                                    9400                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   29025                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         

 

oracle 組函數