InterviewSolution
Saved Bookmarks
| 1. |
write the SQL commands to answer the queries based on fabric table |
| Answer» SQL commands :-a) insert into fabric values ("F005", "Kurta", " woollen" ,5 );b) select fname from fabric where disc>10;c) select * from fabric where type ="woollen" ;d) update fabric set disc= dics+ disc * 10/100 where fname="shirt" ;e) delete from fabric where fabid=F03 ; | |