Skip to main content
Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

How to get the most frequent event?

cancel
Showing results for 
Search instead for 
Did you mean: 
akramhakim621
Contributor
Contributor

How to get the most frequent event?

Last Update:

Sep 21, 2022 5:11:51 PM

Updated By:

Sue_Macaluso

Created date:

Dec 4, 2018 3:55:35 AM

Attachments

I have a table with a column named event. In the column there is a set of data A,B,A,C,A.
How can I get the most frequent event happened by using aggregation count and max?

Tags (1)
Labels (1)
Comments
akramhakim621
Contributor
Contributor

 The output should be the event which is A, not the frequency of the event happened. 
Really appreciate if anyone can help. 

Thanks.

0 Likes
Contributors
Version history
Last update:
‎2022-09-21 05:11 PM
Updated by: