According to Wikipedia.com
The GROUP BY clause is used to project rows having common values into a smaller set of rows. GROUP BY is often used in conjunction with SQL aggregation functions or to eliminate duplicate rows from a result set. The WHERE clause is applied before the GROUP BY clause.
Depending on the Dialect of SQL, modifiers and functions can be applied to GROUP BY.
Functions can include:
Other Definitions Provided by