Hi,
In teradata sql's we can use a function called RANK . Has anyone come across a similar function which can be used in WebFOCUS....

Thanks,
kalyan.

I don't know anything about Terradata and you did not specify or explain what this rank function does. There is a rank command in Focus but whether it is an equivelant of what your Terradata rank is you will have to decide. The following request shows its use:

TABLE FILE CAR
PRINT CAR MODEL
RANKED BY HIGHEST 5 RETAIL_COST
END

PAGE 1


RANK RETAIL_COST CAR MODEL
---- ----------- --- -----
1 31,500 MASERATI DORA 2 DOOR
2 17,850 JENSEN INTERCEPTOR III
3 14,123 BMW 3.0 SI 4 DOOR AUTO
4 13,752 BMW 3.0 SI 4 DOOR
5 13,491 JAGUAR XJ12L AUTO