>how to obtained the percentage.in this sql how to obtained %tage.
>
>SELECT subcode,scode,lcode,sec,fail,total, total/fail%100 as per ;
> FROM Stafft;
>group BY scode,lcode,sec;
>order BY lcode;
>into CURSOR olevelt
If you want to compare total against fail, and express that as percentage:
total/fail * 100
or probably you need it the other way around:
fail/total * 100
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)