# TopCount

Returns the specified number of top-most rows in 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 that is supplied by the <rank expression> argument determines the decreasing order of rank for the rows that are supplied in the <table expression> argument, and the number of top-most rows that is specified in the <count> argument is returned.

For example, assume that the following Sub-SELECT statement returns the table below:

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

Product name | Probability |
---|---|

Apples |
0.4 |

Kiwi fruit |
0.1 |

Oranges |
0.5 |

Lemons |
0.2 |

The **TopCount** function can be used with the Sub-SELECT statement as follows:

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

This example yields the following results:

Product name | Probability |
---|---|

Oranges |
0.5 |

Apples |
0.4 |

## See Also

#### Reference

Data Mining Extensions (DMX) Function Reference

Functions (DMX)

Mapping Functions to Query Types (DMX)