MySQL Absolute Value

MySQL Absolute Value is used to return the absolute value of a records in table. The keyword abs is used to return the absolute numerical value of a records in a table. It returns you the positive magnitude number irrespective of  any positive and negative numbers.

Understand with Example

The Tutorial describes you to find the Absolute Value in MySQL. To understand the example we use select query to run, that returns you the set of records from table 'emp_table'.

Query

 select * from emp_table;

Output

+--------+----------+-----------------+-----------+
| emp_id | emp_name | emp_designation | emp_value |
+--------+----------+-----------------+-----------+
| 1      | sandeep  | programmer      | -25.88    |
| 2      | suman    | sr. Gr Designer | 0.587     |
| 3      | ravi     | s/w developer   | 91.456    |
+--------+----------+-----------------+-----------+

In this example we use abs keywords to find the absolute value in the sql query. In the given table the column emp_value define float datatype. The select abs(emp_value) returns the numerical value without regards to its sign.

Here the absolute value display of emp_value column:

Query

select emp_value, abs(emp_value) from emp_table;

Output

+-----------+------------------+
| emp_value | abs(emp_value)   |
+-----------+------------------+
| -25.88    | 25.879999160767  |
| 0.587     | 0.58700001239777 |
| 91.456    | 91.456001281738  |
+-----------+------------------+