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 Dec. 14, 2024 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

 

Go Ad-free
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 14 years. He provides courses for Maths, Science and Computer Science at Teachoo