SESSION NAME: SQL Functions - 1.
QUESTION NAME: Minuimum of Items ordered.
TABLE DESCRIPTION:
Write a query that prints the minimum of customerid,
quantity and price in items_ordered table.
Note: Use SQL in-built Function to calculate minimum of
the tuples in items_ordered table.
The statement has to return a single result which
contains the minimum value of customerid, quantity and
price columns of everything returned in the items_ordered
table.
quantity and price in items_ordered table.
Note: Use SQL in-built Function to calculate minimum of
the tuples in items_ordered table.
The statement has to return a single result which
contains the minimum value of customerid, quantity and
price columns of everything returned in the items_ordered
table.
CODE:
select min(customerid),min(quantity),min(price) from items_ordered;
0 Comments