In my Postgresql database, the Student table has student_marks and total_marks columns.
I want to get the percentage based on student marks.
For example:
student_marks * 100 / total_marks => 118 * 100 / 147 = 80.27 = 80%
If the first two digits of decimal number are below 50, ex: 75.49 then it should be 75% or if the first two digits of decimal number are equal to 50 or above 50, ex: 67.50 or 67.52 then it should be 68% so
This query works for me:
select TO_CHAR(19.57, 'fm99%') as abc;
it returns 20%.
The problem is of the student get 100% marks:
select TO_CHAR(100, 'fm99%') as abc;
returns ##%
Please show me a solution for this or else suggest another way to do this.
Thank you.
