5 Replies Latest reply: Jan 4, 2013 4:51 AM by Saaz Ena RSS

    multiple row convert into single row

    Saaz Ena
      Hi All

      How do I convert multiple rows into single row data. For example.....

      I am looking for oracle query for below table output that would
      have a sql query output as query output below.

      I was trying with connect by but was unable to prepare query.

      Could some one please help me with sql query.

      Table output_
         ---------------------------
          ID      TYPE        VALUE
          ---------------------------
          1012    1           2
          1012    6           77
          1015    1           1
          1015    6           78
          1018    1           2
          1018    6           79
      Query output_
          ----------------------------    
          ID      VALUE1      VALUE2
          ----------------------------
          1012    2           77
          1015    1           78
          1018    2           79 
      thanks in advance
      Saaz