Boring programmer logo!
How to select the first/least/max row per group in SQL at Xaprb
First bookmarked by
at Mon Jul 13 18:35:31 -0400 2009
Bookmarked by 1 people
Jul 13 09
In general, these types of “select the extreme from each group” queries can be solved with the same techniques. I’ll explain how to do that in this article, including the harder problem of selecting the top N entries, not just the top 1.