Analytic Queries in Vertica

Moderator: NorbertKrupa

Post Reply
User avatar
Site Admin
Site Admin
Posts: 1824
Joined: Sat Jan 21, 2012 4:58 am

Analytic Queries in Vertica

Post by JimKnicely » Mon Oct 02, 2017 6:22 pm

Great blog post "Analytic Queries in Vertica"!

Analytic functions handle complex analysis and reporting tasks. Here are some example use cases for Vertica analytic functions:
  • Rank the longest standing customers in a particular state
  • Calculate the moving average of retail volume over a specific time
  • Find the highest score among all students in the same class
Check it out here: ... _p=5065791
Jim Knicely


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”