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",