Question

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

Answer 1

A) INSERT INTO TABLE NAME ( FabricID, Fname, Type, Disc)

   VALUES ( 'F005', 'Kurta', 'Woolen', '5') ;

B) SELECT * FROM TABLE NAME

   WHERE  Disc > 10;

C) SELECT * FROM TABLE NAME

    WHERE  Type = 'Woolen';

D) UPDATE TABLE NAME

    SET Disc = 20

     WHERE Fname = 'Shirt';

E) DELETE * FROM TABLE NAME

   WHERE FabricID = 'F003';