Write the SQL commands to answer the queries based on Fabric table
FabricID Fname Type Disc F001 Shirt Woollen 10 F002 Suit Cotton 20 F003 Tunic Cotton 10 F004 Jeans Denim 5 F006 Shorts Cotton 7
Answers
Answered by
1
FOR SELECT :-
SELECT*FROM FABRIC
Answered by
4
Answer:
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';
Explanation:
Similar questions