Compute the global rank of the column

[Dai, Kevin]

Hi, All


I want to compute the rank of some column in a table.


Currently, I use the window function to do it.


However all data will be in one partition.


Is there better solution to do it?


Regards,

Kevin.