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