Minimum - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
fcf1492702067123.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

The standard minimum function is supported, generating MIN (expression) and returning a value of type matching the type of the expression. When dragging a Minimum into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Aggregation > Minimum

Columns and/or other non-aggregate expressions can be moved over the (empty) branch of the tree.

The option to compute the minimum over distinct values only is provided, resulting in the generation of MIN(DISTINCT expression). This option is enabled through the Properties panel. Double-click on Minimum, or highlight it and click Properties.

Variable Creation > Input > Variables: SQL Elements pane - Aggregation > Minimum Properties