RCOUNT函数

RCOUNT

This function takes a set of records as input and counts the number of records encountered so far.

This function resets its values for each group in the query according to the rules described in Display Function Reset Behavior .

Syntax:

RCOUNT (Expr)

Where:

Expr


An expression of any data type.

Example:

The following example shows a query that uses the RCOUNT function and the query results.

select month, profit, RCOUNT(profit) from sales_subject_area where profit > 200.

MONTH    PROFIT     RCOUNT (profit

MAY         300.00           2
JUNE        400.00           3
JULY         500.00           4

AUG          500.00          5
SEPT         500.00          6
OCT          300.00          7