Check sibling questions

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

 

  1. Computer Science - Class 12
  2. Solutions to CBSE Sample Paper - Computer Science Class 12

About the Author

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo