Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sep 21, 2022 5:11:51 PM
Sue_Macaluso
Dec 4, 2018 3:55:35 AM
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?
The output should be the event which is A, not the frequency of the event happened. Really appreciate if anyone can help. Thanks.