INNER JOIN with GROUP BY Subquery - Kalman Toth
INNER JOIN with GROUP BY subquery (derived table) is demonstrated using SQL Server 2012 AdventureWorks2012 sample database. The result is formatted, including the new FORMAT function, and sorted with ORDER BY.
Book/Kindle: SQL Programming & Database Design Using Microsoft SQL Server 2012 [Paperback] Kalman Toth (Author)