Home Forums SQL Server 2005 SQL Server 2005 General Discussion Column summary RE: Column summary
John Mitchell-245523
SSC Guru
Points: 148809
More actions
May 10, 2013 at 5:09 am
#1614136
Is this homework? What have you tried so far?
Here's a hint: use GROUP BY and COUNT(*) in a CTE or subquery to find out how many of each product there are, and then use MAX to find out which one has the most.
John