Question

What is the sql commands to answer the queries on fabric table?

Answer 1

A) INSERT INTO TABLENAME (FabricID, Fname, Type, Disc)

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

B) SELECT * FROM TABLENAME

     WHERE Disc >10;

C) SELECT * FROM TABLENAME

      WHERE TYPE = 'Woolen';

D) UPDATE TABLENAME

    SET Disc = '20'

    WHERE Fname = 'Shirt';

E) DELETE * FROM TABLENAME

   WHERE FabricID = 'F003';

Read more on Brainly.in - https://brainly.in/question/8139905#readmore