The GROUP BY Clause

The GROUP BY clause groups together data in the tabular structure generated and filtered by a query's FROM and WHERE clauses, and produces a single row in a query's result set for each distinct group.

Topics include the following:

  • Grouping is More Than Sequencing
  • Out of Many, One
  • How GROUP BY Works
  • Rules for GROUP BY
  • Wrapping Up: the GROUP BY



Visit Website

Code Archive

Sample Applications & Examples

Simply SQL

Publisher: SitePoint

Author: Rudy Limeback

Year: 2008