Write the output (i-iii) for the following SQL commands. TABLE: FASHION ID F01 F02 F03 F04 F05 F06 Product Kajal Foundation Night Cream Day Cream Shampoo Lipstick Price 970 2100 1700 1400 1200 850
Advertisements
Advertisements
प्रश्न
Write the output (i-iii) for the following SQL commands.
TABLE: FASHION
| ID | Product | Price | Qty |
| F01 | Kajal | 970 | 10 |
| F02 | Foundation | 2100 | 15 |
| F03 | Night Cream | 1700 | 20 |
| F04 | Day Cream | 1400 | 10 |
| F05 | Shampoo | 1200 | 25 |
| F06 | Lipstick | 850 | 32 |
SELECT COUNT (Product) FROM FASHION;SELECT SUM (Price*Qty) FROM FASHION WHERE Product = "Night Cream";SELECT LEFT (Product, 4) FROM FASHION WHERE Price>1500;
लघु उत्तर
Advertisements
उत्तर
- 6
- 34000
- Foun
Nigh
shaalaa.com
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
