From: "Steve Long" <steven.long@erols.com>
Newsgroups: alt.comp.databases,comp.databases,comp.databases.theory
Subject: Re: matrix transpose in SQL?
Date: Thu, 26 Apr 2001 14:56:21 -0400
Lines: 25
Message-ID: <9c9r5q$hci$1@bob.news.rcn.net>
References: <9c9l22$f9g$1@stlnews.stl.ibm.com>
X-Trace: UmFuZG9tSVbYNM4vxATA6bXHWsRByhhdgUar37oaySlrvCGEdnD6wTIAShiRRkg0LPjTiZe3JUc=
X-Complaints-To: abuse@rcn.com
NNTP-Posting-Date: 26 Apr 2001 18:59:06 GMT
X-MimeOLE:  Produced By Microsoft MimeOLE V5.50.4133.2400
X-Priority:  3
X-Newsreader:  Microsoft Outlook Express 5.50.4133.2400
X-MSMail-Priority:  Normal


yes, you can.

"Aakash Bordia" <a_bordia@hotmail.com> wrote in message
news:9c9l22$f9g$1@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
>
>
>