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
productbuy_pricesell_pricedifference
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
productbuy_pricesell_pricedifferenceABS_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

More about SQL Where condition Query

The SQL Dump of this table is here
CREATE TABLE IF NOT EXISTS `plus2_price` (
  `product` varchar(10) NOT NULL,
  `buy_price` int(3) 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);

Subscribe to our mailing list

* indicates required
Subscribe to plus2net
Visitors Rating
Your Rating


Google+
▼ More on Math functions in SQL

Post Comment This is for short comments only. Use the forum for more discussions.




Subscribe to our mailing list

* indicates required
Subscribe to plus2net




HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us
©2000-2017 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer