Ankitware is a platform where you get NIIT dumps fully solved!!!!! NIIT Lab At Home ;
NIIT Pmr ,NIIT cycle test, Window app.
Contact:ankitware@gmail.com.
Thursday, 10 October 2013
11. Display a report containing the product ID and the total cost of products for the product ID whose total cost is more than $ 10,000. (Use the AdventureWorks database)
select ProductID,sum(LineTotal) as Total from sales.salesorderDetail Group by productID Having sum(LineTotal)>10000
No comments:
Post a Comment