Monday, 7 November 2016

SQL SERVER AGREGATES

SQL SERVER AGREGATES


SELECT MIN(ANNUALREVENUE) MINIMUM,MAX(ANNUALREVENUE) MAXIMUM, AVG(ANNUALREVENUE) AVERAGE,SUM(ANNUALREVENUE) TOTAL


FROM AdventureWorksDW2012.DBO.DimReseller;


Figure 3 aggregates

Posted by at
Labels:
Location: United States

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)