Re: select 10 highest results
see this:
SELECT lem1, lem2, max(smc) AS max_smc FROM smc GROUP BY lem1, lem2;
how many results are returned now?
I think it might be a good idea to post what you actually want to do, maybe that group by condition is not the right one, and you put that just so you could use sum()...
Subject
Written By
Posted
Re: select 10 highest results
August 23, 2005 08:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.