FORUM
HTML
ASP
PHP
JavaScript
Search
Contact Us
SQL Home
>
Date
Math
String
PHP MySQL
abs functions
We can get absolute value by using abs function. This function takes one numeric input data. Here is an example
select abs(-2.3)
Output of above code is 2.3
select abs(+4.567)
Ouput is 4.567
select abs(0.23)
It is 0.23
avg:Getting average of data in MySQL
sum:Sum of a range of data in MySQL
sum of multiple columns in MySQL & to get Percentage and total
min:Getting the Minimum value of data in MySQL
max:Getting the Miximum value of data in MySQL
mod:Getting the reminder of a division by using Mod function
Getting second highest number from the student table
format: Formatting MySQL data in a query while managing records of a table
floor: MySQL function to get highest integer lower than the input value
ceil: MySQL function to get lowest integer higher than the input value
abs: MySQL abs function to get absolute value
round: MySQL round function to get rounded value from column
sign: MySQL sign function to get sign of numbers
conv: MySQL conv to convert numbers from one base to other
oct: MySQL oct to convert numbers from decimal to Octal system
truncate: MySQL truncate function to remove decimal places
sqrt: square root of number by sqrt function
Post Comment
This is for short comments only. Use the
forum
for more discussions.
Name
Email
( not to be displayed)
Privacy Policy
1+2=
This is to prevent automatic submission by spammers. Please enter the result of the sum as asked
Join Our Email List
Email:
For
Email Newsletters
you can trust
MySQL Math
Math Functions
sum
sum Percentage
average
ceil
floor
Minimum
Maximum
Mod
2nd Highest
Formatting
abs
round
sign
conv
oct
Truncate
sqrt
