SESSION NAME: SQL Functions - 1.
QUESTION NAME: Absolute Mathematical Functions.
TABLE DESCRIPTION:
Display all the details from the items_ordered table by
using (select * from items_ordered table).
Perform Absolute function (abs) for the columns
customerid, price and quantity respectively.
Note: The final result should have only customerid, price
and quantity
using (select * from items_ordered table).
Perform Absolute function (abs) for the columns
customerid, price and quantity respectively.
Note: The final result should have only customerid, price
and quantity
CODE:
select abs(customerid), abs(price), abs(quantity) from items_ordered;
0 Comments