Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
rank function
 Login/Join
 
<Kalyan>
posted
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.
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 115 | Location: Chicago, IL | Registered: May 28, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.