Oracle Analytic Functions (aggregates)

[Juan Angulo]

Hi,

I am trying to create a data repository on MySQL for historic data from a transactional system that uses Oracle as its database. Actually, I'm trying to convience people of doing it on MySQL rather than Oracle.

The problem that I am facing is that all of the reports, queries (and several other processes) that originally fetched this data from the Oracle DB rely heavily on Oracle specific functionality - Analytic Functions.

Is there any way to do stuff like the rough example below without having to do several sub-queries?

select distinct field_a, field_b, field_c,
first_value(field_m) over (partition by field_a order by field_b desc) x,
first_value(field_n) over (partition by field_a order by field_c desc) y,
sum(field_o) over (partition by field_a, field_b) z
from table;

I know the example is not very specific (and would probably duplicate data the way it was written, but it describes the point well).

Any help/suggestions would be very appreciated.

Thank you,