Hi,

I'm using OracleBI Discoverer 10g and I need to use GROUP BY (SQL function) function. I don't know which Oracle function is equivalent to GROUP BY function which I use in basic SQL.

For example, I have two amounts (amount 1 and amount 2) and I need to SUM them based on the ID number - in SQL I would solve this problem like this:

SELECT ID_NUMBER, SUM(AMOUNT_1 + AMOUNT_2) AS "TOTAL_AMOUNT"
FROM EMPLOYEE
GROUP BY ID_NUMBER

Can you tell me how should I make THIS calculation in Oracle? Which Oracle function should I use?

Thank you very much,
Goran.