MySQL Forums
Forum List  »  Newbie

Re: select the last record in each group
Posted by: Peter Brawley
Date: March 27, 2016 02:29AM

doc, I cannot understood the rules you cite for generating your desired result; without more clarity, I cannot help you.

And again, to solve slowness, post the result of Explain Extended on the query.

Or if you don't wish to do that, study the examples under "Within-groupo aggregates" at http://www.artfulsoftware.com/infotree/queries.php

Options: ReplyQuote


Subject
Written By
Posted
Re: select the last record in each group
March 27, 2016 02:29AM


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.