# 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

Let us try ABS Query in a table where we have two columns for each product storing Purchased ( buying ) price and selling price. We will first list the difference in price like this
``SELECT product, buy_price, sell_price, sell_price - buy_price AS difference FROM `plus2_price``
Output is here
Product110155
Product12015-5
Product110100
Product120255
Now let us apply ABS function by modifying the query.
``````SELECT product, buy_price, sell_price, sell_price - buy_price AS difference,
ABS( sell_price - buy_price ) AS ABS_difference FROM plus2_price``````
difference
Product1101555
Product12015-55
Product1101000
Product1202555

## ABS With WHERE Query

``````SELECT product, buy_price, sell_price, sell_price - buy_price AS difference, ABS( sell_price - buy_price ) AS ABS_difference FROM plus2_price
WHERE ABS( sell_price - buy_price ) >0``````
The SQL Dump of this table is here
``````CREATE TABLE IF NOT EXISTS `plus2_price` (
`product` varchar(10) NOT NULL,
`sell_price` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `plus2_price`
--

INSERT INTO `plus2_price` (`product`, `buy_price`, `sell_price`) VALUES
('Product1', 10, 15),
('Product1', 20, 15),
('Product1', 10, 10),
('Product1', 20, 25);``````
Visitors Rating

▼ More on Math functions in SQL

Post your comments , suggestion , error , requirements etc here .