Re: MAX and GROUP problem. Help!
Posted by:
359359
Date: May 20, 2005 06:11AM
Hi,
I've did this:
SELECT test.*
FROM test LEFT JOIN test AS s2
ON test.ELEMENT=s2.ELEMENT AND test.VALUE<s2.VALUE
WHERE s2.ELEMENT IS NULL
...and it is working file but when I run on the bigger DB (50.000 rows) it take's me 35 min. Is there any fastes way?
Subject
Written By
Posted
Re: MAX and GROUP problem. Help!
May 20, 2005 06:11AM
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.