Re: matrix transpose in SQL?
From: Steve Long <steven.long_at_erols.com>
Date: Thu, 26 Apr 2001 14:56:21 -0400
Message-ID: <9c9r5q$hci$1_at_bob.news.rcn.net>
Date: Thu, 26 Apr 2001 14:56:21 -0400
Message-ID: <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 - 20:56:21 CEST