item_type: Vegetables itemNumber ItemName quantity price 101 Potato 10 20.00 102 Tomato 102 10.00 item_type: Fruits: itemNumber ItemName quantity price 103 Mango 2 30.00 104 Apple 4 40.00
select item_number,item_type,item_name ,quantity ,price from purchase_order order by item_type;
item_number item_type item_name quantity price 3 fruits Dates 3 57.900 6 fruits Jackfruit 34 10.890 1 vegetables Ladies Finger 23 45.000 3 vegetables Broad Beans 23 53.900
SELECT item_type, item_number, item_name, quantity ,price FROM purchase_order ORDER BY item_type
item_type
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)