TopCount

The TopCount function returns the specified number of topmost rows in a decreasing order of rank as specified by an expression.

Syntax

TopCount(<table expression>, <rank expression>, <count>)

Applies to

An expression that returns a table, such as a <table column reference> or a function that returns a table.

Return Type

<table expression>

Remarks

The value supplied by the <rank expression> argument is used to determine the decreasing order of rank for the rows supplied in the <table expression> argument, and the number of topmost rows specified in the <count> argument is returned.

For example, assume that this Sub-SELECT contains the following table:

(SELECT [Product Name], $Probability AS [Probability] FROM Predict([Products Purchases], INCLUDE_STATISTICS))

Product Name	Probability
Apples	0.4
Kiwi	0.1
Oranges	0.5
Lemons	0.2

Using the TopCount function with the Sub-SELECT as a parameter as shown yields the following results:

TopCount((SELECT [Product Name], $Probability AS [Probability] FROM Predict([Products Purchases], INCLUDE_STATISTICS)), [Probability], 2)

Product Name	Probability
Oranges	0.5
Apples	0.4