on 05-09-2013 6:03 AM
Hi All,
We have analytical function PERCENT_RANK function in ORACLE. We got requirement to implement same in SAP HANA, however i don't see persent rank function in SAP HANA.
Can anyone tell me how to do it..?
Regards,
Venkat.
Hi Venky,
PERCENT_RANK() is supported now. Are you still getting any issues or this is solved?
Can you check once?
Regards,
Krishna Tangudu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I haven't used PERCENT_RANK in Oracle before, but the following - in combination with your percent calculation from your other post - might help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.