The standard count function is supported, generating either COUNT(*) or COUNT (expression) and returning a value of type integer in Teradata run mode or decimal(15,0) in ANSI run mode. When dragging a Count into a variable, the following tree element is created.
If the Count element is dropped or selected onto an empty node, an Asterisk (*) is generated by default, resulting in the familiar COUNT(*) SQL phrase. If, however, the Count element is dropped or selected onto a node that is not empty, the contents of the target node replaces the Asterisk under the resulting Count node. The Asterisk may also be replaced by moving a non-aggregate expression over it in the tree. If necessary, an Asterisk can be restored by moving an Asterisk element from the Other category of SQL Elements.