MySql Absolute Value
This example illustrates how to find the absolute value of the table.
This example illustrates how to find the absolute value of the table.MySql Absolute Value
This example illustrates how to find the absolute value of the table.
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 type when we select the abs(emp_value) then the output display below.
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 | +--------+----------+-----------------+-----------+ |
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 | +-----------+------------------+
|
