Check sibling questions

Question 9 (i) - CBSE Class 12 Sample Paper for 2022 Boards [Term 2] - Computer Science - Solutions to CBSE Sample Paper - Computer Science Class 12

Last updated at March 16, 2023 by

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

Slide42.JPG

Slide43.JPG
Slide44.JPG

 

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

Book 30 minute class for ₹ 499 ₹ 299
Ask a doubt
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

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