Neoview SQL Reference Manual (R2.4)

I2 RANK
----------- --------------------
? 1
? 1
300 3
200 4
200 4
200 4
100 7
100 7
--- 8 row(s) selected.
Return the rank of I2 descending, excluding NULL values:
SELECT I2, RANK (I2) AS RANK
FROM cat.sch.seqfcn
WHERE I2 IS NOT NULL
SEQUENCE BY I2 DESC;
I2 RANK
----------- --------------------
300 1
200 2
200 2
200 2
100 5
100 5
--- 6 row(s) selected.
RANK/RUNNINGRANK Function 429