select 'Maximum'=MAX(TotalDue),'Mininum'=MIN(TotalDue),'Average'=AVG(TotalDue) from sales.salesorderHeader
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.
Subscribe to:
Post Comments (Atom)
-
select SalesPersonID as 'Sales Person ID', TerritoryID as 'Territory ID', SalesQuota as 'Sales Quota' from Sales....
-
Niit NIIT NIIT D C Chowk New Delhi 1800 102 6448 CALL DIRECTIONS NIIT NIIT HD-7, 2nd Floor, Main Metro Road, Opp. Metro Pillar No....
-
select salesorderID,MIN(LineTotal) as 'Minimum',MAX(LineTotal) as Maxinum from sales.salesorderDeteil where LineTotal>5000 group...
No comments:
Post a Comment