Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
BottomCount
Collapse the table of content
Expand the table of content

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:
© 2015 Microsoft