Focal Point
rank function

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4671008331

October 15, 2004, 10:37 AM
<Kalyan>
rank function
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.
October 15, 2004, 11:29 AM
ET
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