Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Add a data grouping clause

Avatar

Level 2

Hi team,

 

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

Kumar_27_0-1707299891174.png

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

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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.

View solution in original post

2 Replies

Avatar

Correct answer by
Employee Advisor

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.

Avatar

Level 2

Hi @Craig_Thonis ,

 

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