on 2022 Jun 01 10:06 AM
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?
Request clarification before answering.
User | Count |
---|---|
49 | |
10 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.