MySQL Forums
Forum List  »  Optimizer & Parser

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?

Options: Reply• Quote


Subject
Views
Written By
Posted
Re: slow corelated subquery, not sure how to rewrite
2186
September 03, 2006 12:00AM


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.