5 Replies Latest reply: Aug 26, 2014 2:50 PM by Frank Kulash RSS

    how can i display aggregated column with other columns

    1044098

      I have emp Table Having This Structure

           EMPNO ENAME      JOB              MGR HIREDATE         SAL     COMM     DEPTNO

      ---------- ---------- --------- ---------- --------- ---------- ---------- ----------

            7839 KING         PRESIDENT            17-NOV-81       5000                              10

            7698 BLAKE      MANAGER         7839 01-MAY-81       2850                           30

            7782 CLARK      MANAGER         7839 09-JUN-81       2450                            10

            7566 JONES      MANAGER         7839 02-APR-81       2975                           20

            7788 SCOTT      ANALYST         7566 19-APR-87       3000                             20

            7902 FORD       ANALYST         7566 03-DEC-81       3000                             20

            7369 SMITH      CLERK           7902 17-DEC-80        800                                20

            7499 ALLEN      SALESMAN        7698 20-FEB-81       1600         300             30

            7521 WARD       SALESMAN        7698 22-FEB-81       1250        500            30

            7654 MARTIN     SALESMAN        7698 28-SEP-81       1250      1400           30

            7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0            30

            7876 ADAMS      CLERK           7788 23-MAY-87       1100                            20

            7900 JAMES      CLERK           7698 03-DEC-81        950                              30

            7934 MILLER     CLERK           7782 23-JAN-82       1300                              10

       

      I wnat to display The Empno , ename ,hiredare, deptno and sum of sal dept wise

      This should the output....

       

      empno ename   hiredate       deptno  sum(saL)

      7839    KING     17-NOV-81   10          8750

      7698    BLACK  1-MAY-81     30          9400

      .

      .

      7900 JAMES   03-DEC-81    30            9400

      7934 MILLER   23-JAN-82    10            8750