Add a data grouping clause

[Kumar_27]

Hi team,

Does anyone explain the use of  "Add a data grouping clause" in query activity? share any use case for this concept.

@_Manoj_Kumar_ @ParthaSarathy @Craig_Thonis @DavidKangni @Marcel_Szimonisz @david--garcia @Denis_Bozonnet @isahore @AnanthanJa @AkshayAnand 

[Craig_Thonis · Accepted solution]

Hi Kumar,

The Add a grouping clause means that you are adding a Group By to the generated SQL statement. To understand how a Group By works, check out the documentation below:

https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-group-by/

To put it simply, as the name suggests, the function allows results to be grouped by certain criteria such as grouping recipients by country.

[Kumar_27]

Hi @Craig_Thonis ,

Thanks for your response. For my better understanding please provide any use case / Hands-on it's very helpful to understanding.