Absolute value of any data by ABS function in MySql

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);

Output 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

product	buy_price	sell_price	difference
Product1	10	15	5
Product1	20	15	-5
Product1	10	10	0
Product1	20	25	5

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;

product	buy_price	sell_price	difference	ABS_ difference
Product1	10	15	5	5
Product1	20	15	-5	5
Product1	10	10	0	0
Product1	20	25	5	5

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 NOT NULL,
  sell_price INT NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

SQL Math References SIGN function : Sign of the argument

All Math Functions ROUND()

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com