Is there anyway in DB2 to convert rows to columns?
In other words, if I have the following table below...
MemberID AccountNum ZipCode
------------------------------------
1234 1 45645
1234 2 45647
1859 1 36363
I want to move the ZipCode rows to columns grouped by MemberID...
MemberID Zip1 Zip2
----------------------------
1234 45645 45647
1859 36363