GroupBy

Generates a GROUP BY clause in an SQL database query.

Visual SQL Query Builder dialog box, with the GroupBy tab displayed

Selected Table(s)

Displays the table or tables which are currently selected.

GroupBy Fields

Displays the fields of the table displayed in Tables which can be used in a GROUP BY clause. This list box will be empty unless the query being generated includes an aggregate function (see Functions option menu).

Having Fields

Displays the field selected in the GroupBy Fields list box. The display in this field is modified if subsequently a selection is made in the Functions option menu. For example, if MSLINK is displayed and Maximum Value of is selected from the Functions option menu, then MAX(MSLINK) is displayed.

Operator

Displays the last operator selected in either Common Operators or Additional Operators.

Value

Displays the value selected in the Value text box.

Common Operators

See Common Operators on the Where tab page.

Additional Operators

See Additional Operators on the Where tab page.

Functions

See Functions on the Select tab page.

Clear

Deletes the line selected in the Having Fields list box.

Apply

Generates the GROUP BY clause displayed in the Having Fields list box in the SQL Select Statement text box.