To create a summary of records based on the common value in a field in different rows of the table GROUP BY clause is used.
