Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: complex? SQL time series problem

Re: complex? SQL time series problem

From: Geoff M <gmuldoonnospam_at_scu.edu.au>
Date: Tue, 15 Feb 2005 10:51:03 +1100
Message-ID: <MPG.1c7be4726a5436889896b5@news.individual.net>


Mark.Powell_at_eds.com says...
> Geoff, wouldn't that be just group by c_set, stts, (e_date - s_date)
> with a matching select list plus count(*)?

Can't see it. More simply, I need to eventually plot this against a date dimension, so I need:

 s_date       e_date     c_set  c_id  stts
01-jan-2000  15-mar-2000  a2     125   A
17-jul-2000  sysdate      a2     125   A
14-may-2000  sysdate      a2     158   A

to become: 
c-set   stts     s_date      e_date       count(c_id)
a2       A     01-jan-2000  15-mar-2000      1
a2       A     14-may-2000  16-jul-2000      1
a2       A     17-jul-2000  sysdate          2

Need to derive an e_date value of 16-jul-2000 amongst other things.

Geoff M Received on Mon Feb 14 2005 - 17:51:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US