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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Find the store with the Max Sales for each month

Re: Find the store with the Max Sales for each month

From: Mark Anthony <mdejesus_at_gmail.com>
Date: 3 Sep 2004 11:29:35 -0700
Message-ID: <c95e8e39.0409031029.20048a2f@posting.google.com> 





thx rob! RANK WAS THE KEY!



"rob" <rob_at_dsdelft.nl> wrote in message news:<ch9cmt$c0g$1_at_news.tudelft.nl>...


> "rob" <rob_at_dsdelft.nl> wrote in message news:ch9ccb$brg$1_at_news.tudelft.nl...

> > Mark,

> >

> > Take a look at "SQL for Analysis" chapter 17 in Oracle8i Data Warehousing

> > Guide (CUBE and ROLLUP).

> 

> That should be (RANK end DENSE_RANK)

> 

> >

> > Regards,

> > Rob

Received on Fri Sep 03 2004 - 13:29:35 CDT












Original text of this message













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