cancel
Showing results for 
Search instead for 
Did you mean: 

How to implement dense_rank() in BODS? gen_row_num_by_group dosnt work always

0 Kudos
237

Hello Team,

Say I have below data, and I need to find the third highest salary . we cannot use gen_row_num_by_group directly here and get salary where rank=3:

NAME SALARY gen_row_num_by_group()

AA 1000 1

BB 2000 2

BB 2000 2

DD 3000 5

EE 2000 2

FF 9000 6

What should be the workaround for this?

Accepted Solutions (0)

Answers (0)