Group By Work

GROUP BY is a standard SQL command that groups rows with the same value in the specified column. You should use with aggregate functions such as COUNT, MIN, MAX, etc.

The query below illustrates the GROUP BY clause:

SELECT columnName FROM Table
GROUP BY columnName