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
https://my.vertica.com/blog/analytic-qu ... _p=5065791