The GROUP BY clause restricts the rows of the result set; there is only one row for each distinct value in the grouping column or columns.

• GROUP BY子句限制结果集中的行数,每个不同的值在组合列中只占一行。