matrix transpose in SQL?
From: Aakash Bordia <a_bordia_at_hotmail.com>
Date: Thu, 26 Apr 2001 10:17:21 -0700
Message-ID: <9c9l22$f9g$1_at_stlnews.stl.ibm.com>
Date: Thu, 26 Apr 2001 10:17:21 -0700
Message-ID: <9c9l22$f9g$1_at_stlnews.stl.ibm.com>
Hello, Can we do matrix transpose (row become columns and columns become
rows) in standard SQL?
1 2 3
changes to
1 4 7
eg:
4 5 6
7 8 9
2 5 8
3 6 9
Thanks
Aakash
Received on Thu Apr 26 2001 - 19:17:21 CEST