SQL group by aggregates Archives - Anuj Varma, Hands-On Technology Architect, Clean Air Activist

Tag archives for SQL group by aggregates

sql aggregates and group by

October 14, 2014 sql aggregates and group by2014-10-14T15:15:53-05:00 SQL Server, Denali No Comment

When you select an aggregate (such as count (*), ) you also need to do a group by on the results. Select ,count() as NumberOfBooks from AUTHOR a join BOOKS…