MySQL Forums
Forum List  »  Newbie

Re: Using ORDER BY and GROUP BY together
Posted by: Graham Roberts
Date: August 10, 2005 10:44AM

Many thanks for the response Felix, and the link - I had tried, (but failed!) to find a page like that. That said, the solution mentioned is one that I started using, but my concern was that the number of queries involved might be excessive and cause problems - using in the example at the link you specify we would already have roughly 70000 articles and this is growing at asay 200 a day, sometimes more.

I guess I should try both techniques and see which is most efficient.

Also, can you confirm whether the GROUP BY solution I'm using is guaranteed to always use details from the first record in the group, rather than it being a case of random selection. My tests indicate this is the case but I'd appreciate your view.

Many thanks once again.

Graham Roberts

Options: ReplyQuote


Subject
Written By
Posted
Re: Using ORDER BY and GROUP BY together
August 10, 2005 10:44AM


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.