Mode Analytical Function in Vertica

guptamayank

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 ?

sKwa

Hi!

Can you describe more? Why you can't implement it with analytical function - COUNT ? Can you give an example?

• COUNT (analytical)
• DENSE_RANK (analytic)

---

• Calculate mode in SQL (dense_rank)
• Calculate mode in SQL (count)