Re: matrix transpose in SQL?
From: Aakash Bordia <a_bordia_at_hotmail.com>
Date: Thu, 26 Apr 2001 13:13:31 -0700
Message-ID: <9c9vcc$e80$1_at_stlnews.stl.ibm.com>
Date: Thu, 26 Apr 2001 13:13:31 -0700
Message-ID: <9c9vcc$e80$1_at_stlnews.stl.ibm.com>
great! How?
Thanks
Aakash
"Steve Long" <steven.long_at_erols.com> wrote in message
news:9c9r5q$hci$1_at_bob.news.rcn.net...
> yes, you can.
>
> "Aakash Bordia" <a_bordia_at_hotmail.com> wrote in message
> news:9c9l22$f9g$1_at_stlnews.stl.ibm.com...
> > Hello, Can we do matrix transpose (row become columns and columns become
> > rows) in standard SQL?
> > eg:
> >
> > 1 2 3
> > 4 5 6
> > 7 8 9
> >
> > changes to
> >
> > 1 4 7
> > 2 5 8
> > 3 6 9
> >
> > Thanks
> > Aakash
> >
> >
> >
>
>
Received on Thu Apr 26 2001 - 22:13:31 CEST