DB2 OS/390 V8.2. No OLAP functions. I am trying to developed them.
Thank's in advance>
Serge Rielau wrote:
>> I have a problem with following join:
>> First query is generating RANK
>[quoted text clipped - 44 lines]
>>
>> Please help to constract a join to generate Bonus,Row_number and Rank
>Which version of DB2 and which platform?
>Note that DB2 for LUW supports OLAP functions for all supported
>versions. There is no need for joins
>
>Cheers
>Serge
>

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200803/1