Calculating AVG on DENSE_RANK FIRST

AnandaBasakAnandaBasak
in General Discussion

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?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...