Difference between revisions of "NUMERIC BUILT IN FUNCTIONS"
Jump to navigation
Jump to search
(Created page with "==ROUND()== ROUND(49.113212) = 49.11 ==CEIL()== '''Integer value that is greater than or equal to the number''' CEIL(48.99)=49 ==POWER()== POWER(4,2)=16 ==SQRT()== SQR...") |
|||
| Line 1: | Line 1: | ||
==ROUND()== | ==ROUND()== | ||
ROUND(49.113212) = 49.11 | ''' THE , 2 AT THE END IS NUMBER OF PLACES TO ROUND''' | ||
ROUND(49.113212,2) = 49.11 | |||
==CEIL()== | ==CEIL()== | ||
| Line 15: | Line 16: | ||
''' Returns the largest of multiple value''' | ''' Returns the largest of multiple value''' | ||
GREATEST(9,67.6,10)67.6 | GREATEST(9,67.6,10)67.6 | ||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | |||
Revision as of 19:16, 5 November 2017
ROUND()
THE , 2 AT THE END IS NUMBER OF PLACES TO ROUND
ROUND(49.113212,2) = 49.11
CEIL()
Integer value that is greater than or equal to the number
CEIL(48.99)=49
POWER()
POWER(4,2)=16
SQRT()
SQRT(16)=4
GREATEST()
Returns the largest of multiple value
GREATEST(9,67.6,10)67.6