Saved Bookmarks
| 1. |
Write the SQL commands to answer the queries based on Fabric tableFabric IDFnameTypeDiscF001ShirtWoollen10F002SuitCotton20F003TunicCotton10F004JeansDenim5F005ShortsCotton7a. To insert the following record (“F005”, “Kurta”, “Woollen”,5) b. To display only those fabric whose disc is more than 10 c. To display those records whose type is “Woollen” d. To modify the fabric shirt by increasing discount by 10 e. To delete the record of fabric ‘F003’ from table |
||||||||||||||||||||||||
Answer»
a. insert into Fabric values (‘F005’, ‘Kurta’, ‘Woollen’,5); b. select * from Fabric where Disc>10; c. select * from Fabric where type = ‘Woollen’; d. update fabric set Disc = Disc + 10 where name = ‘Shirt’; e. delete from Fabric where FabricID =‘F003’; |
|||||||||||||||||||||||||