Export (0) Print
Expand All

BottomSum

SQL Server 2000

BottomSum

Sorts a set using a numeric expression and returns the specified number of bottommost elements whose sum is at least a specified value.

Syntax

BottomSum(«Set», «Value», «Numeric Expression»)

Remarks

This function sorts on «Numeric Expression» and picks up the specified number of bottommost (the smallest number possible) elements such that their sum is at least «Value».

Important  The BottomSum function, as with the TopSum function, always breaks the hierarchy.

Example
BottomSum(Products.[Product Description].Members, 100000, Quantity)
 

See Also

TopSum

Show:
© 2014 Microsoft