The Question : A table, ITEM has been created in a database with the following fields: ITEMCODE, ITEMNAME, QTY, PRICEGive the SQL command to add a new field, DISCOUNT (of type Integer) to the ITEM table.
Solution for the question :
ALTER TABLE Item ADD (Discount INT);
The correct answer to the question is researched by our moderators and shared with you. You can give feedback by commenting for the answers you think are wrong.