MySQL Forums
Forum List  »  Oracle

Oracle Analytic Functions (aggregates)
Posted by: Juan Angulo
Date: October 20, 2004 11:42AM


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,

Options: ReplyQuote

Written By
Oracle Analytic Functions (aggregates)
October 20, 2004 11:42AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.