Mode Analytical Function in Vertica

Hi, We are trying to migrate from SAS to Vertica. Some of our code in SAS uses Mode function (to get the most frequently occurring element out of the list). I couldn't find an analytical function in Vertica that we can use for that purpose.

Can anyone please throw some light if there is something already available in Vertica that we are missing ?


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file