On Mon, Jan 13, 2014 at 6:53 AM, Petite Abeille <petite.abei...@gmail.com> wrote: > On Jan 12, 2014, at 8:23 PM, Larry Martell <larry.mart...@gmail.com> wrote: > >> AFAIK, there is no way to do this in SQL. > > Sounds like a job for window functions (aka analytic functions) [1][2].
That's my thought too. I don't think MySQL has them, though, so it's either going to have to be done in Python, or the database back-end will need to change. Hard to say which would be harder. ChrisA -- https://mail.python.org/mailman/listinfo/python-list