Skip to main content

Mode Analytical Function in Vertica

  • June 1, 2017
  • 1 reply
  • 5 views

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 ?

1 reply

sKwa
Forum|alt.badge.img+1
  • Participating Frequently
  • July 18, 2017

Hi!

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