- 5. Grouping and Windowing
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
For instance, if a grouping set contains Country, State, City, it doesn't make sense to aggregate just City. Cities in different countries and states have the same name, but it is not an appropriate classification for grouping.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/60639/