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

Home -> Community -> Usenet -> comp.databases.theory -> Re: SQL problem enclosed. SELECTing moving window of values...

Re: SQL problem enclosed. SELECTing moving window of values...

From: Lennart Jonsson <lennart_at_kommunicera.umea.se>
Date: Wed, 07 Nov 2001 22:10:07 GMT
Message-ID: <3jiG7.16697$xS6.26774@www.newsranger.com> 






Remo, this is just an idea but you might be able to extend it something that is
working



select monthname(a.changedate), count(1)
from workstat as a, (select distinct month(changedate) from workstat) as b(m)
where month(a.changedate) >= b.m and a.changedate <= '3/1/2000' and
a.wostat = 'INPRG' group by monthname(a.changedate)




/Lennart
Received on Wed Nov 07 2001 - 16:10:07 CST












Original text of this message













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