Hello ladies and gentlemen.
If we have the following records (as example) from a query:
is it possible to present the following sql result with pl/sql oracle query ?
We need to have the single ALPHA CODE record, the analytic BETA CODE record related to the alpha code from the first query, and SUM of the VALUE record = 30 and not 90 (3 x 30).
Thank you very much for your help in advance.