Hi.. IT knowledge lovers.. you are on m site at “We Are
Knowledge”.. In here you will getting and take many IT knowledge… You will
getting and take ?? let’s do read this article…
Previosly I was discuss about “fuction”. Like as : string
function and date and time function.. Now I want add tutorial about function, that
is “Numerical Function”.
Many Arithmetic operations about it, Like as :
1. + := increase 2. - := decrease
3. * := multiple 4. / := divide
5. % := mod
And this is Numerical Function :
A. ABS
>> to take the absolute value
B. MOD
>> to take the residual value for a integer
C. FLOOR and CEILING
>> for floor to take the greatest integer value
>> for ceiling to
take the smallest integer value
D. ROUND
>> this function is used for rounding the value as 'n'
characters. If the function is more than 15 then rounded up, and if kurng of 15
rounded down
E. POW or POWER
>> This function produces the value of the rank
F. RAND
>> This function produces a random value
G. TRUNC
>> this function cuts the value as 'n', for decimal
H. GREATEST
>> function takes the greatest value on the set of
values. Utility function is almost equivalent to the 'max'
I. COUNT and SUM
>> to count the number of lines used to take
>> to sum used to add value in each row
J. MAX, MIN, and AVG
>> to max is used to find the greatest value. Utility
function is almost equivalent to the ‘greatest’
>> for min is used to find the smallest value
>> to avg used to take an average value. Or for this
function we change all the values in the column 'x', then the result is
divided by the number of scores.
Ok.. just it..
See you later friends…
No comments:
Post a Comment