Re: Question about Oracle Discoverer

From: K Sudhakaran <sudhakaran_k_at_zipmail.com>
Date: 13 Mar 2002 21:36:26 -0800
Message-ID: <7099f945.0203132136.471501eb_at_posting.google.com>


Hi pal

I dunno abt discoverer..but using normal SQL I am putting my idea here.

Having a table ( may be temporary table ) with top 10 products ( of sale or whatever ) ordered based on the sales..performing a join of the second ( here say your custormer table ) without any order by clause may get you the needed result which will be in the order of top 10 selling products.It wud be more interesting if u reply abt how far it worked out and still if it is not solved...

Also I wud like to see more clearer version of your question.

Regards
Sudhakaran.K

"N. K. Chidambaran" <chiddi_at_tulane.edu> wrote in message news:<Rwqi8.2152$E_3.264031_at_news2.east.cox.net>...
> I am using Oracle Discoverer to do some SQL queries.
> How do I sort the rows based on, say, top ten selling prodcuts? Or bottom
> ten percent of customers who spent the least amount of money?
>
> Thanks so much
Received on Thu Mar 14 2002 - 06:36:26 CET

Original text of this message