CEIL and FLOOR Function in Sql

 CEIL and FLOOR:-


SELECT
     CEIL(109.19)  ceil_val,
       FLOOR(109.99) floor_val from dual;
      
      
ROUND:-
      
       ROUND( number, decimal_places [, operation ] )
      
       SELECT ROUND(125.315, -2) from DUAL;
      
       SELECT ROUND(6.2,-2) from DUAL;
      
     
      SELECT INVOICE_AMOUNT FROM AP_INVOICES_ALL
     
        SELECT INVOICE_NUM,ROUND(INVOICE_AMOUNT) FROM AP_INVOICES_ALL WHERE INVOICE_AMOUNT = '15629.33'