Hi All,
Here is a sample table "employee_contribution"
| ID | Name | Contribution Amount |
| 1 | John | $10000 |
| 2 | Alex | $54541 |
| 3 | Ram | $25000 |
| 4 | Scott | $5000 |
| 5 | Daniel | $2500 |
From the above table, I need to return the total contribution amount and names of those people who are responsible for top 80% of the contribution using pl/sql logic. I need to write a stored procedure but I am not sure how do it. Please help me with the logic.
Thanks,
Santhosh.