I have to perform below task in oracle 10.2 .Can you please help.
Question :
In case of multiple percentage value of COMPLIMENT appeared in TEXT field for the same APP_ID, always populate the COMPLIMENT percentage with most occurrence.
DATA:
| APP_ID | TEXT |
| 00000005 | 50% COMPLIMENT FOR TMJ SERVICES WHEN AUTHORIZED AS N |
| 00000005 | $100 CONDITION FOR PRE AND |
| 00000005 | WHAT 50% COMPLIMENT LERGY |
| 00000005 | INCASE OF 50% COMPLIMENT SERVICES PERFORMED BY IN FULL |
| 00000005 | $50 LESS; CONDITION WAIVED IF AP |
| 00000005 | PLY |
| 00000005 | 30% COMPLIMENT LIMITED TO ONE PROGRAM OF WHICH INCL |
| 00000005 | 30% COMPLIMENT WHAT SO EVER |
| 00000005 | 20% COMPLIMENT; IN VITRO FERTILIZATION IS NOT COVERED |
| 00000005 | 10% COMPLIMENT FOR SPECIFIC |
Expected Output: 50%
Because the 50% occurs most of the time in the field text.
Thanks appreciate your help!!