(Rob Gravelle) The GROUP BY clause is ideal for breaking up aggregate functions into groups. However, it’s not so great for displaying multiple rows within each group that meet a given criteria.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help