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 |
+-----------+------------------+
|

|