SELECT - SQL Command - GROUP BY Clause

The GROUP BY clause specifies one or more columns used to group rows returned by the query. Columns referenced in the SQL SELECT statement list, except for aggregate expressions, must be included in the GROUP BY clause. You cannot group by Memo, General, or Blob fields.

For the complete syntax, see SELECT - SQL Command.

The detailed syntax for the GROUP BY clause is as follows:

[GROUP BY Column_List_Item [, ...] ]

Parameters

• Column_List_Item
  Specifies one or more columns used to group rows returned by the query.

Column_List_Item can be one of the following:

• A field in a table in the FROM clause or a subquery.

• A table alias from the SQL SELECT list.

• A numeric expression indicating the location of the column in the result table. The leftmost column is number 1.

Remarks

The following code shows a summary of the main clauses of the SELECT - SQL Command:

SELECT Select_List
   FROM Table_List
...[WITH (BUFFERING = lExpr)]
   [WHERE Conditions]
   [GROUP BY Column_List]
   [HAVING Conditions]
   [UNION Clause]
   [ORDER BY Column_List]
   [INTO Clause | TO Clause ]
   [Additional_Display_Options]

For more information about a particular clause of the SQL SELECT command, see the following topics:

• SELECT Clause

• FROM Clause

• SELECT - SQL Command - WITH Clause

• SELECT - SQL Command - WHERE Clause

• HAVING Clause

• UNION Clause

• ORDER BY Clause

• INTO or TO Clause

• Additional Display Options

See Also

Reference

CREATE QUERY Command
CREATE TABLE - SQL Command
MODIFY QUERY Command

Other Resources

Working with Queries
Working with Views (Visual FoxPro)
Query and View Designers