Do we have any function similar to PERCENT_RANK that uses denserank instead of rank

General
Teradata Employee

Do we have any function similar to PERCENT_RANK that uses denserank instead of rank

Hello ,

 

Currently I'm using PERCENT_RANK

PERCENT_RANK=(RANK-1)/(NR-1)

 

Is there any similar function which uses dense rank

   (DENSERANK-1)/(NR-1)  or do we have any alternative

 

Thanks in advance.

2 REPLIES

Re: Do we have any function similar to PERCENT_RANK that uses denserank instead of rank

Nice Article. thanks for sharing.

 

Teradata Employee

Re: Do we have any function similar to PERCENT_RANK that uses denserank instead of rank

Nothing built in. Compute it yourself, using DENSE_RANK and COUNT functions.