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_at_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 - 20:29:35 CEST

This message: [ Message body ]
Next message: Ana C. Dent: "Re: Java Tree In Oracle Forms"
Previous message: Mark D Powell: "Re: Reorder Primary Key - any problem?"
Maybe in reply to: Mark Anthony: "Find the store with the Max Sales for each month"
In reply to rob: "Re: Find the store with the Max Sales for each month"
Next in thread: Mark D Powell: "Re: Find the store with the Max Sales for each month"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message