SQL Syntax in the SQL Statement Builder

SELECT

Create a new SELECT statement.

SELECT DISTINCT

Select the Omit Duplicate Records option on the Statement Options tab.

INSERT

Create a new INSERT statement.

UPDATE

Create a new UPDATE statement.

DELETE

Create a new DELETE statement.

CALL

Create a new CALL statement.

WHERE

Set a filter condition in the Query Specification tab.

SUM

Select the Group Records Together option on the Statement Options tab, and select SUM from the Group column on the Select/Sort tab.

MAX

Select the Group Records Together option on the Statement Options tab, and select MAX in the Group column on the Select/Sort tab.

MIN

Select the Group Records Together option on the Statement Options tab, and select MIN in the Group column on the Select/Sort tab.

AVG

Select the Group Records Together option on the Statement Options tab, and select AVG in the Group column on the Select/Sort tab.

GROUP BY

Select the Group Records Together option on the Statement Options tab, and select BY in the Group column on the Select/Sort tab.

COUNT (*)

Select the Group Records Together option on the Statement Options tab, and select COUNT in the Group column on the Select/Sort tab.

HAVING

Select the Group Records Together option on the Statement Options tab, and right-click a name in the Item column on the Select/Sort tab. When the context menu appears, select the Add Group Criterion command to display the Specify Criterion wizard. Refer to Building Criteria to learn more about using this wizard.