Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

indicates rounded to tens, 0 rounded to rupee, 1 rounded

to ten paisa's

12.10 How to use mod( ) function

SYNTAX: select  mod(8 , 3)  "modulus" from dual ; RESULT:

modulus

-----------

2

Though, there were many functions are available, we are concentrating  as  recap  and  some  very   important functions frequently used and likely to be used in our proposed application development,

Now our next task is to analyses some of the Aggregate functions,

Aggregate Functions: These functions  mainly forming part of statistical nature since, it considers all the rows of a table and pick out one value among suiting to the function nature, For example, day wise rain-fall has been maintained in a table and "select max(rainfall) "max", min(rainfall) "min", avg(rainfall) "avg",