This function ranks the highest n values of the expression
argument from 1 to n, 1 corresponding to the highest numeric value. The TOPN
function operates on the values returned in the result set. A request can
contain only one TOPN expression.
Syntax: TOPN(expr, integer)
Syntax description
expr is any
expression that evaluates to a numerical value.
integer is
any positive integer. Represents the top number of rankings displayed in the
result set, 1 being the highest rank.
Example: TOPN("Sales"."Rp
Revenue",12)
No comments:
Post a Comment