Group By Dialog Box

Type directly into the statement box, or use the lists and buttons to build your SQL query.

Finished statement

In this box, add a GROUP BY clause to your SELECT statement to specify how to group the resulting data after the requested calculation (function) is performed.

This clause is necessary when a function and multiple fields are specified in your SELECT statement.

Fields

This box displays the fields in the selected file(s). For more information about a field, hover your mouse over the field name.