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