Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to write a sql query

How to write a sql query

From: magesh <magesh_at_garoo.ne.jp>
Date: Wed, 22 Nov 2000 20:34:33 +0900
Message-Id: <10688.122716@fatcity.com>


Hi All

   How to write a sql query to print in the matrix report. Eg . Test table .

       a1    b1
        1     2.3
        1     3.5
        1     7.0
        2     1.7
        2     2.6
        2     2.9
        3     1.3
        3     2.9
        3     3.0


I need the output ,should be

     1           2.3      3.5     7.0
     2           1.7.     2.6     2.9
     3           1.3      2.9     3.0


Please , Any one suggest me how to write a sql query for this.

Thanks & Regards Received on Wed Nov 22 2000 - 05:34:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US