SQL Challenges-1: Convert negative numbers to positive and vice verse

SQL Challenges-1: Exercise-11 with Solution

From the following table, write a SQL query to convert negative numbers to positive and vice verse. Return the number.

Input:

Table: tablefortest

Structure:

Data:

Sample Solution:

SQL Code(MySQL):

DROP TABLE IF EXISTS tablefortest; 
CREATE TABLE tablefortest(srno int,  pos_neg_val int);
INSERT INTO tablefortest VALUES (1, 56);
INSERT INTO tablefortest VALUES (2, -74);
INSERT INTO tablefortest VALUES (3, 15);
INSERT INTO tablefortest VALUES (4, -51);
INSERT INTO tablefortest VALUES (5, -9);
INSERT INTO tablefortest VALUES (6, 32);
select * from tablefortest;

SELECT srno,pos_neg_val,-1 *(pos_neg_val) AS converted_signed_value 
FROM tablefortest;

Sample Output:

srno|pos_neg_val|converted_signed_value|
----|-----------|----------------------|
   1|         56|                   -56|
   2|        -74|                    74|
   3|         15|                   -15|
   4|        -51|                    51|
   5|         -9|                     9|
   6|         32|                   -32|

SQL Code Editor:

Contribute your code and comments through Disqus.

Previous: Find active customers.
Next: Century of a given date.