To Use the Visual SQL Query Builder to Build a Query: Example 2

Note: Aggregate functions (Max, Min, Count, Sum, and Avg) operate only in Cursor mode. Clicking Execute places the Query Builder in Cursor mode. The Dataset Mode check box is off.

In the Visual SQL Query Builder dialog ( Drawing > Attach > Database > Open Visual Query Builder ), click Clear All to clear everything.
In the Select tab page, click Tables or from the Tables menu choose Open.
The Select Table dialog opens.
In the Select Table dialog, double-click Parcel.
The Parcel dialog opens.

The SQL Select Statement now reads:
```
SELECT
FROM Parcel
```
In the Select Table dialog, click Cancel.
Click the Functions options menu button, and select Maximum Value of.
In the Parcel dialog, double-click Parc_area.
The SQL Select Statement updates to the following, indicating the query is complete:
```
SELECT  MAX(parc_area) 
FROM Parcel
```
Click the Execute button to review the results based on this query.
If Output > Forms is turned on with Dataset Mode selected, the following form is generated.

If Output > Browser is turned on, the same results are displayed in the Visual SQL Data Browser dialog.
Click Clear All to delete the table and the SQL query.