• Image 1
  • Image 2
  • Image 3
  • Image 4
  • Image 5
  • Image 6
  • Image 7




Monday, September 17, 2012

NUMERICAL FUNCTION IN MYSQL


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