Contact Us
SQL
Math Functions
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
Be the first to post comment on this article :
Tweet
More on Math functions in SQL
Math functions used in SQL
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
pow: Power of a number pow 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
SQL Applications
•
SQL Like to search with wildcard
•
Copy structure or Data from one table to other
•
SQL Left join to get matching records
•
Getting highest of Maximum record
•
Searching for keywords in a table