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);
Last updated at Dec. 14, 2024 by Teachoo
Answer
ALTER TABLE Item
ADD (Discount INT);
CBSE Class 12 Sample Paper for 2022 Boards [Term 2] - Computer Science
Question 2 (i)
Question 2 (ii) Important
Question 3 Important
Question 4
Question 5 Important
Question 6 Important
Question 7 (Choice 1)
Question 7 (Choice 2) Important
Question 8 (Choice 1)
Question 8 (Choice 2) Important
Question 9 (i) You are here
Question 9 (ii) Important
Question 10 Important
Question 12 (i) - Choice 1
Question 12 (i) - Choice 2 Important
Question 11 Important
Question 12 (ii)
Question 13 Important
About the Author
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