Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

TopCount

SQL Server 2000

TopCount

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

Syntax

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

Remarks

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

Important  Like the BottomCount function, this function always breaks the hierarchy.

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

See Also

BottomCount

Show:
© 2015 Microsoft