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 ?