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);


Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class