Write query based upon item table given. Itemno Iname Price Quantity 101 Soap 50 100 102 Powder 100 50 103 Face cream 150 25 104 Pen 50 200 105 Soap box 20 100 Display a report with item number,
Advertisements
Advertisements
प्रश्न
Write query based upon item table given.
| Itemno | Iname | Price | Quantity |
|---|---|---|---|
| 101 | Soap | 50 | 100 |
| 102 | Powder | 100 | 50 |
| 103 | Face cream | 150 | 25 |
| 104 | Pen | 50 | 200 |
| 105 | Soap box | 20 | 100 |
Display a report with item number, item name and total price. (total price = price * quantity).
कोड लेखन
Advertisements
उत्तर
SELECT Itemno, Iname, Price * Quantity AS TotalPrice FROM Item;shaalaa.com
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
