Export (0) Print
Expand All

BottomCount

SQL Server 2000

BottomCount

Returns a specified number of items from the bottom of a set, optionally ordering the set first.

Syntax

BottomCount(«Set», «Count»[, «Numeric Expression»])

Remarks

This function sorts a set according to the value of «Numeric Expression» and returns the bottom «Count» members, where «Count» is a numeric expression.

Important  The BottomCount function, as with the TopCount function, always breaks the hierarchy.

Example
BottomCount(Geography.Cities.Members, 5, Sales)
 

See Also

TopCount

Show:
© 2014 Microsoft