7.00.02 - Example 3: Specify Maximum Number of Rows in Any Partition - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

This example uses the NumberOfRows argument. With this argument, the function orders the rows as specified in the ORDER BY clause, and then converts exactly number_of_rows rows into columns. The column names are generic: value_0, value_1, and so on. If there are more than number_of_rows rows in a partition, the function ignores the extra rows. If there are fewer than number_of_rows rows in a partition, the function adds NULL values so that there are a total of number_of_rows columns.