BottomCount

BottomCount

The BottomCount function returns the specified number of bottommost rows in increasing order of rank as specified by an expression.

Syntax

BottomCount(<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 increasing order of rank for the rows supplied in the <table expression> argument, and the number of bottommost rows specified in the <count> argument is returned.

For more information, see TopCount.