Re: slow corelated subquery, not sure how to rewrite
Posted by:
Tait Larson
Date: September 03, 2006 12:00AM
I think this is much easier than I thought using aggregators.
Select city_code, attributes, max(create_time) from marketdata_apartments group by city_code;
max(create_time) chooses the max create_time from the EACH group.
Sound right?
Subject
Views
Written By
Posted
3886
September 01, 2006 06:42PM
Re: slow corelated subquery, not sure how to rewrite
2186
September 03, 2006 12:00AM
2039
September 10, 2006 10:18PM
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.