Re: RPG embedded SQL GROUP BY with cursor

[Booth Martin <booth@xxxxxxxxxxxx>]

I plead guilty.  At the moment I am a bit angry with myself for not 
having discovered sql earlier.  So far my problems with sql have tended 
toward my over-thinking the tasks.  This group by issue is one more 
example of a simple answer that I could not find.

The problem I am having with Googling for answers is that I don't know 
yet how to frame the questions in a way to get answers that relate.

In any event, I do appreciate the courtesy and the answers.  Its been 
pleasing.

On 1/13/2016 5:51 PM, Michael Schutte wrote:
> Booth, from what I remember you were good at what you do! So I'm wondering why you are posting such a simple question.
>
> You need to google "group by clause". Simple search will lead to what you are doing wrong.
>
> I will also recommend googling "group by rollup" clause
>
> Sent from my iPhone