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
14. Display the sales order ID and the maximum and minimum values of the order based on the sales order ID. In addition, ensure that the order amount is greater than $ 5,000. (Use the AdventureWorks database)
select salesorderID,MIN(LineTotal) as 'Minimum',MAX(LineTotal) as Maxinum from sales.salesorderDeteil where LineTotal>5000 group by salesorderID
No comments:
Post a Comment