Skip to main content

Calculating AVG on DENSE_RANK FIRST

  • July 29, 2015
  • 0 replies
  • 0 views

AnandaBasak

I have following syntax in Oracle SQL query:

SELECT AVG(sal) KEEP (DENSE_RANK FIRST ORDER BY sal)

 

How to write this code in Vertica?