Ask Experts Questions for FREE Help !
Ask
    gogo26's Avatar
    gogo26 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Mar 12, 2009, 01:37 AM
    OracleBI Discoverer 10g - using GROUP BY function
    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.

Check out some similar questions!

Group - A & Group-T shares [ 2 Answers ]

Hi, I just want to know what are Group-A shares & Group-T shares and what we mean by that. On what basis this groupings are done

Oracle Discoverer Interview Questions [ 3 Answers ]

Hi, I'm preparing for an interview. I found these from some of the topic questions. The last time I used Oracle Forms/Reports was more than 2 years ago. My computer does not have a Personal Oracle so I can at least see the Help file, nor do I have yet the books to refer to. It will be very...

The result of increasing and decreasing function on the composite function [ 6 Answers ]

I was asked to prove the result of increasing and decreasing function on the composite function... prove that: 1- if f(X) inc & g(X) inc, foG inc 2-if F(X) inc & G(X) dec, foG dec 3- if F(X) dec & G(X) inc, fog dec 4- if f(X) dec & G(X) dec, fog inc please help me in that

What group? [ 1 Answers ]

Who sings the 70s funk song "Cisco Kid"?

View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.