Write the SQL commands for the following on the basis of following table. (2X4=8)
To display names of those garments that are available in "XL" size.
To display garment name, code and price of those garments that have prices in a range 1000 to 1500 (both 1000 and 1500 are included).
To change the colour of garments with code as 116 to "Orange".
To insert a new row in the table with following values:
117, "Shirt", "L", "W
Answers
Answered by
0
Answer:
which class please tell me
Answered by
0
Answer : (i) Select Gname from garment where size = 'XL' ;
(ii) Select Gcode, Gname, Price from garment where price between 1000 and 1500 ;
(iii) Update garment set colour = 'Orange' where Gcode = 116 ;
(iv) sorry, i don't know
(ii) Select Gcode, Gname, Price from garment where price between 1000 and 1500 ;
(iii) Update garment set colour = 'Orange' where Gcode = 116 ;
(iv) sorry, i don't know
Similar questions