Select Column Advanced Dialog Box

The Select Column Advanced dialog box specifies a function call, composes an expression, or enters an alternative column label in a SQL Spreadsheet query. You can access the Select Column Advanced dialog box only from the Columns tab of the SQL Query Builder Wizard.

Control

Description

Function

Enables you to enter a function call related to the column selected on the Column tab of the SQL Query Builder wizard.

  • None

  • Average

  • Count

  • Maximum

  • Minimum

  • Sum

Expression

Enables you to manually enter a RDBMS supported function call for the column selected on the Column tab of the SQL Query Builder wizard.

Displayed As

Enters an alternative column label in the SQL Spreadsheet query for the column selected on the Column tab of the SQL Query Builder wizard.