RE: SQL rows to columns

Very cool! Glad to have found something that adds to our knowledge.


Vern


On Thu, 14 Mar, 2024 at 8:43 AM, Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:


To: midrange systems technical discussion

Thanks Vern... That is a great explanation.

I did it this way... but I didn't need to use the ROW_NUMBER() over (PARTITION BY) because my table already contains a unique sequence number within the "partition".


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> On Behalf Of VERNON HAMBERG Owner via MIDRANGE-L
Sent: Wednesday, March 13, 2024 7:07 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx<mailto:vhamberg@xxxxxxxxxxxxxxx>>; midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL rows to columns

Looks like Kent Milligan wrote this article - one of the IBM database people, article looks very well laid out. Example is a bit simpler than what is asked for here, but can extended pretty easily.


Regards
Vern


On Wed, 13 Mar, 2024 at 1:59 PM, Glenn Gundermann <glenn.gundermann@xxxxxxxxx<mailto:glenn.gundermann@xxxxxxxxx>> wrote:


To: midrange systems technical discussion

I don't know if this helps but this article's title mentions pivot.

https://db2ibmi.blogspot.com/2023/07/pivoting-with-sql.html

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx<mailto:glenn.gundermann@xxxxxxxxx><mailto:glenn.gundermann@xxxxxxxxx<mailto:glenn.gundermann@xxxxxxxxx>>
Cell: (416) 317-3144