Currently I'm using PERCENT_RANK
Is there any similar function which uses dense rank
(DENSERANK-1)/(NR-1) or do we have any alternative
Thanks in advance.
Nothing built in. Compute it yourself, using DENSE_RANK and COUNT functions.