It seems as though I am required to pass in an argument to RANK().

What is the effect of passing this argument in ?

In a RANK function the output for RANK should be the number of rows
preceding
a row in a given window. As  windows are specified by the partition and
order by fields I don't understand the effect of passing in an arg to RANK

Are the other non-aggregate function similar? Meaning : Cume_dist, Ntile
-- 


https://github.com/bearrito
@deepbearrito

Reply via email to