5. Consider the following table named …
CBSE, JEE, NEET, CUET
Question Bank, Mock Tests, Exam Papers
NCERT Solutions, Sample Papers, Notes, Videos
5. Consider the following table named "GARMENT". Write command of SQL for (i) to (iv).
PRICE
1400.00
1600.00
1100.00
4000.00
1500.00
1200.00
Pink
Brown
Blue
L
L
GCODEMA
(i) To display names of those garments that are available in 'XL' size.
Table: GARMENT
SIZE
Red
Blue
Black
XL
XL
L
M&E
GNAME
TShirt
HD Jeans
Skirt
Ladies Jacket
Trousers
Ladies Top
COLOUR
To display codes and names of those garments that have their names starting with Ladies'. (iii) To display garment names, codes and prices of those garments that have price in the range 1000.00 to 1500.00 (both 1000.00 and 1500.00 included).
(iv) To change the colour of garment with code as 116 to "Orange".
111
112
113
114
115
116
(ii)
Posted by Avni Jain 1 year, 11 months ago
- 0 answers
ANSWER
Related Questions
Posted by Kandeepan Jothivel 1 year, 1 month ago
- 2 answers
Posted by Hanni Pham 11 months, 2 weeks ago
- 0 answers
Posted by Hanni Pham 11 months, 2 weeks ago
- 1 answers
Posted by Priya Shukla 1 year ago
- 1 answers
Posted by Syedali Fathima 1 year ago
- 1 answers
Posted by Prawar Narang 1 year, 1 month ago
- 1 answers
myCBSEguide
Trusted by 1 Crore+ Students
Test Generator
Create papers online. It's FREE.
CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app