|
Write the output of SQL Queries (i) to (iv) and write output for v based on ITEM table
<!--[if gte vml 1]> <![endif]--><!--[if !vml]--> <!--[endif]-->
<!--[if !supportLists]-->(i) <!--[endif]-->To display all INAME from ITEMS table in descending order of their
PRICE
<!--[if !supportLists]-->(ii) <!--[endif]-->To display all ITEMS details whose price is in range of 15000 and
25000
<!--[if !supportLists]-->(iii) <!--[endif]-->To display Sum of price and TCode where Qty i s more than 50
TCode wise (for each TCode)
<!--[if !supportLists]-->(iv) <!--[endif]-->To delete all ITEMS from table where CODE i s 1003
<!--[if !supportLists]-->(v) <!--[endif]-->Select TCode, sum(price) from ITEMS group by TCode where count(*)>1
| 
