select salesorderID,MIN(LineTotal) as 'Minimum',MAX(LineTotal) as Maxinum
from sales.salesorderDeteil
where LineTotal>5000
group by salesorderID
from sales.salesorderDeteil
where LineTotal>5000
group by salesorderID
Subscribe to:
Post Comments (Atom)
-
select SalesPersonID as 'Sales Person ID', TerritoryID as 'Territory ID', SalesQuota as 'Sales Quota' from Sales....
-
Q2. What are the lines of latitude? Ans. Lines of Latitude are the Imaginary Horizontal lines running East to West circling the Earth. Th... -
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....
No comments:
Post a Comment