Tag: sql

Selecting rows holding group-wise maximum is a favorite problem of mine, but one which only rarely pops up. But for some reason, after my last blog post on the subject, it seems to be mentioned almost daily around here. Something that I forgot to mention in the previous post is that most of the examples… Continue reading Selecting rows holding group-wise maximum of a field, part two

Today there was a question on the Freenode MySQL channel about a classical problem: Rows holding group-wise maximum of a column. This is a problem that I keep encountering every so often, so I thought I would write up something about it. A good example of the problem is a table like the following holding… Continue reading Selecting rows holding group-wise maximum of a field