MySQL Forums
Forum List  »  Newbie

Re: group by without subselects in MySQL 4
Posted by: Felix Geerinckx
Date: August 23, 2005 04:05AM

Seth Ladd wrote:

> We need to find all events where PURCHASED is the last event. In other words, where
> PURCHASED events have the latest timestamp. We need this grouped by owner_id.
>
> We're not sure how to do this without subselects.

See http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Written By
Posted
Re: group by without subselects in MySQL 4
August 23, 2005 04:05AM


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.