Skip to main content

Mode Analytical Function in Vertica

  • Jun 1, 2017 4:05 PM UTC
  • 1 reply
  • 6 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
  • Jul 18, 2017 12:07 PM UTC

Hi!

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