Analytical query help

From: RA <angani_at_gmail.com>
Date: Mon, 7 Dec 2009 13:01:42 -0800 (PST)
Message-ID: <a10dbe89-a4ce-404c-a965-cac35f88af14_at_z10g2000prh.googlegroups.com>

Hi gurus,

Could anyone show me how to write a analytical query for my requirement.

Query

---

SELECT distinct bug_when,

       login_name,
       SUM(incoming_count - outgoing_count)
        OVER (PARTITION BY login_name ORDER BY bug_when) AS OPEN
FROM RM_COMP_INCOM_OUTGO_BUGIDS_GT G,
     bz_components c,
     bz_profiles p

where G.component_id= c.ID and
c.manager = p.userid
order by 2,1 desc;

Query returns data like this

---

12/04/2009 ssmit 52
12/02/2009 ssmit 48
11/30/2009 ssmit 45
11/29/2009 ssmit 42

I want the data to be like this

---

12/04/2009 ssmit 52
12/03/2009 ssmit 48 -- fill the gap with previous value
12/02/2009 ssmit 48
12/01/2009 ssmit 45
11/30/2009 ssmit 45
11/30/2009 ssmit 45
11/29/2009 ssmit 42

Table Desc

---

CREATE GLOBAL TEMPORARY TABLE RM_COMP_INCOM_OUTGO_BUGIDS_GT (
  BUG_WHEN DATE,
  COMPONENT_ID NUMBER,
  INCOMING_COUNT NUMBER,
  OUTGOING_COUNT NUMBER
);

Regards
RA Received on Mon Dec 07 2009 - 15:01:42 CST