Gurus,
Can anyone help me how to convert (roughly) this Cognos SQL to Oracle SQL, which is written for one derived column.
SUM(MAX(COLUMN A for COLUMN B) at COLUMN B) / COUNT ( COLUMN B at COLUMN B)
-------------
I need native SQL for the same, but with above expression, it's splitting Column B as seperate column, and sum() function is taking away decimals from the output.
Many Thanks in Advance
Joys