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
I dunno abt discoverer..but using normal SQL I am putting my idea
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.
Quote:> 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
How well the does the book Oracle Discoverer Handbook
match up w/ the version that is shipping w/ the latest Oracle 9i?
In other words, is this book still relevant w/ the latest release of
Discoverer from Oracle?