Hi All, I have total amount like 110.01, 113.34, 126.01, 145.54, 155.01 etc but I need to round this 100 or 125 or 150 etc.
Please find my requirement below, 1) I need to round to 100 if the total is between 100 to 112. 2) I need to round to 125 if the total is between 113 to 125. 3) I need to round to 125 if the total is between 116 to 137. 4) I need to round to 150 if the total is between 138 to 150. 5) I need to round to 150 if the total is between 151 to 167. 5) I need to round to 200 if the total is between 168 to 200. You help is greatly appreciated. -- Thanks & Regards Swaroop Thailuru Swamy Ph: 713-392-1571 -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
