×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
That looks like exactly what I needed! Couldn't find it in the reference manual because I was looking for something that started with rank.
Scott
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Birgitta Hauser
Sent: Friday, July 20, 2012 11:59 AM
To: 'RPG programming on the IBM i / System i'
Subject: AW: Displaying rankings in several categories simultaneously
What about using embedded SQL in composition with OLAP Ranking Functions:
Select Dense_Rank() Over(Order By Revenue) RankRevenue,
Dense_Rank() Over(Order By Miles) RankMiles,
Dense_Rank() Over(Order BY RPM) RankRPM,
... additional fields
From ...
Where ...
Order By Fldx , Fldy
The fields in the final Order by may be different from the fields specified in the Over(Order By) clauses.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
midrange.com
