Add a data grouping clause

Question

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 @costa_n11 @isahore @ananthanja @akshayanand

Craig_Thonis · Accepted Answer

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.

rahulbabu · Answer

I will share one usecase. Recipients who more than 5 sales
Ex: Two tables are there.
Recipient and product sales.
Add grouping condition like
Count(OrderId) greater than 5.

OrderId is from product sales table. So it will count number of purchases by customer and it is greater than 5. They only will be the target audience

Sign up

Login with SSO

Login to the community

Login with SSO