Question

Write the SQL commands to answer the queries based on fabric table .

a)To insert the following record
("F005","Kurta","Wollen",5)

b)To display only those fabric whose disc is more than 10.

c)To display those record whose type is "Wollen"

d)To modify the fabric shirt by increasing discount of 10.

e)To delete the record of fabric F003 from table

Subject -Computer ​

Answer 1

Answer:

INSERT INTO FABRIC VALUES("F005","Kurta","Wollen",5);

SELECT * FROM FABRIC WHERE Disc>10

SELECT * FROM FABRIC WHERE Type='Wollen'

UPDATE FABRIC SET Disc=Disc+10 where Fname=Shirt

DELETE FROM FABRIC WHERE FabricID='F003'