Show Contents / Index / Search
Group By Dialog Box

Getting there

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.



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

Related Topics

Create an SQL Query

SQL Tab (Transfer Settings Dialog Box)