This discussion is archived
5 Replies Latest reply: Jan 4, 2013 2:51 AM by Saaz Ena RSS

multiple row convert into single row

Saaz Ena Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points