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

Related Tags for MySQL Absolute Value:
sql,  mysql,  c,  table,  sed,  word,  numbers,  key,  value,  number,  return,  tab,  numerical,  record,  keyword,  numeric,  records,  to,  ical,  pos,  e,  it,  use,  pe,  absolute,  in,  negative,  cal,  m,  os,  osi,  ca,  osi,  os,  es,  spec,  positive,  me,  s,  urn,  respect,  sp,  so,  esp,  at,  any,  my,  k,  is,  ir,  iv,  and,  rds,  va,  s,  s,  ri,  rd,  th,  ab,  abl,  ati,  alu,  ga,  gat,  ica,  ica,  nd,  ol,  o

More Tutorials from this section

• MySQL Absolute Value
• MySQL Addition
• MySQL Add Column
• MySQL Affected Rows
• MySQL Area
• MySQL Arithmetic
• MySQL ASC
• MySQL Ascending Command
• MySQL Auto_Increment
• MySQL Boolean Value
• Mysql Switch CASE
• Mysql Check
• MySQL Converting Expression
• Mysql Decimal Datatype
• Mysql Describe
• Mysql Else Condition
• Mysql Exists
• Mysql For Loop
• Mysql From
• PHP SQL IF Statement

Ask Questions?    Discuss: MySQL Absolute Value  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):