A table, ITEM has been created in a database with the following fields:
ITEMCODE, ITEMNAME, QTY, PRICE
Give the SQL command to add a new field, DISCOUNT (of type Integer) to the ITEM table.
Answer
ALTER TABLE Item
ADD (Discount INT);


Get live Maths 1-on-1 Classs - Class 6 to 12