Re: display table row into column

From: <gareth_at_jamms.org>
Date: Thu, 26 Feb 2009 07:10:32 -0800 (PST)
Message-ID: <7cd092cc-f3bd-4855-94c5-3034802ddf5e_at_e5g2000vbe.googlegroups.com>

On 26 Feb, 12:48, shweta.kapar..._at_googlemail.com wrote:
> Hi All
>
> I have :
>
> SQL> create table t1( col1 varchar2(10), col2 varchar2(10),col3
> varchar2(10));
>
> Table created.
>
> SQL>
>
> SQL>  insert into t1(col1,col2,col3) values ('A','B','C');
>
> 1 row created.
>
> SQL> insert into t1(col1,col2,col3) values ('D','E','F');
>
> 1 row created.
>
> SQL>  insert into t1(col1,col2,col3) values ('G','H','I');
>
> 1 row created.
>
> SQL> commit;
>
> Commit complete.
>
> SQL> select * from t1;
>
> COL1       COL2       COL3
> ---------- ---------- ----------
> A          B          C
> D          E          F
> G          H          I
>
> i want to write select query which should give me the output:
> as
>
> col1    col2    col3
> ----     ------    ------
> B       E        H
>
> Regards
>
> Shweta

This is a very popular question. Search the group, or asktom, for "pivot query".

HTH -g Received on Thu Feb 26 2009 - 09:10:32 CST