To Use the Visual SQL Query Builder to Build a Query: Example 2
- In the Visual SQL Query Builder dialog ( ), 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
is turned on with Dataset Mode selected, the following form is generated.If
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.