Can you use a Subquery with a groupby, having and a count

General
1

Hello,

Can you use a Subquery with group-by, having and count? Is that possible?

Cheers,

Michael Iverson

2

Hello @Michael_Iverson

Could you clarify what exactly you want to achieve? Could you provide an example of such a query, based on the schema of your tables?
Maybe these few docs can help you Search with SubQuery or Data Filtering

Regards,
Viktor

3

I want to use subquery, and filter out the results using the groupby and having clauses. Is that Possible? Documentations seems to show the group-by and having clause to only aggregate functions. Can group-by and having clause work for subqueries?

4

Yes, group by and having can work with subqueries. If we can see specific schema diagram and knowing what data you want to retrieve, we’d be able to assist you further.