Re: SQL question

[Javier Sanchez <javiersanchezbarquero@xxxxxxxxx>]

I'd be happy to see Birgitta in action with this, she's a specialist!  Go,
go, Birgitta, please teach us!

JS

El jue, 4 ene 2024 a las 13:50, Michael Mayer (<michael.mayer@xxxxxxxxxxxxx>)
escribió:

> Here's an SQL question for the group...
> I have an SQL that works but I'd like to add a blank line after the Group
> BY ROLLUP.
> How would someone easily (EAS-I-LY) add a blank line to the result set
> after the --- 9 and
> after the --- 7 ???
> Asking for a friend 😉
>
>
> abc  1
> def   2
> ghi   6
> ---    9
> jkl    3
> mno 4
> ---    7
> ---   16
>
>
> Respectfully,
> Michael Mayer
> IBM i on Power System Admin
> ERMCO-ECI
> 2225 Industrial Rd
> Dyersburg, Tennessee 38024
> Office and OnCall: 731.676.4318
> Cell: 518.641.8906
> Email: michael.mayer@xxxxxxxxxxxxx
> https://www.ermco-eci.com
> IBM i Personal Blog: https://ibmireference.blogspot.com
> “Success is not final. Failure is not fatal. It is the courage to continue
> that counts”.
>
>
>
>
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.