MySQL Forums
Forum List  »  General

Re: grouping of second by second records
Posted by: Peter Brawley
Date: April 29, 2014 06:10PM

> how can i SELECT the first and last value in each interval?

You'll find the elements of such logic under "Within-group aggregates" at http://www.artfulsoftware.com/queries.php. Combining banding aggregation and within-group aggregation is difficult but doable. At least for starters, take them one at a time, perhaps saving the results of one process to a temp table before applying the other. When you have it working, then you can look at optimisation.

Options: ReplyQuote


Subject
Written By
Posted
Re: grouping of second by second records
April 29, 2014 06:10PM


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.