Hello,
I have a doubt regarding percentage
I need to fetch only those rows where the amount paid is less than 95 percent.
E.g.
Total Value Amont_Paid
937804 396902
453580 734561
if the amount paid 95% of the total amount, then I should fetch the records.
I have tried as
SELECT * from my_table
where amount_paid < (amount_paid*.95%)
This did not get the correct results.
Appreciate if some could provide some insight.