Urgent: Finding the top 10 NET- SALES- FIGURES [message #20927] |
Tue, 02 July 2002 03:34 |
Deborrah
Messages: 8 Registered: July 2002
|
Junior Member |
|
|
Hi,
I am having query on the Sales table, where
I have to fetch the top 10 sales figures
group by PRODUCT_CODE.
I have the sales figures = AMT1 + AMT2 + AMT3
each of which exist in the same table. I just
sum them up group by PRODUCT_CODE.
How can I get only the top 10 sales figures?
TIA,
Debby
|
|
|
|
Re: Urgent: Finding the top 10 NET- SALES- FIGURES [message #20971 is a reply to message #20929] |
Wed, 03 July 2002 20:35 |
Deborah
Messages: 18 Registered: June 2002
|
Junior Member |
|
|
Hi Mahesh,
Thanks for the reply. It works fine for Ora 8.0.5
onwards.
But I have Oracle 7.3.4. It does not allow an order
by clause in teh subquery. Please advise an alternate
solution. Because the server where I will install my
program has Oracle 7.3
TIA,
Debby
|
|
|
|
|
|