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