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

Home -> Community -> Usenet -> c.d.o.server -> Re: Efficient query for this year/last year/two years ago

Re: Efficient query for this year/last year/two years ago

From: Lerch <mike.lerch_at_gmail.com>
Date: 9 Nov 2006 13:00:53 -0800
Message-ID: <1163106053.042934.88380@h48g2000cwc.googlegroups.com> 






On Nov 9, 1:23 pm, gromane..._at_gmail.com wrote:>You ought to re-think
the whole thing ... have you looked at the


> results from your first query? Is SALES_MTD really what you want ...

> shouldn't the MTD for 200403 be 2400?




Well yes, it certainly should be.  I don't know what I've got wrong in
my analytic function in my sample and have to figure that out. :(
Received on Thu Nov 09 2006 - 15:00:53 CST












Original text of this message













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