- 5. Grouping and Windowing
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Versus adding the company name to the GROUP BY clause, MAX selects the most frequently occurring company name string for the group. Since we know only 1 company name should exist per shipper ID, it is valid in this example.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/60184/