Archive for November 26th, 2009
PostgreSQL: Selecting records holding group-wise maximum
Comments enabled. I *really* need your comment
Continuing the series on selecting records holding group-wise maximums:
How do I select the whole records, grouped on
grouperand holding a group-wise maximum (or minimum) on other column?
In this article, I'll describe several ways to do this in PostgreSQL 8.4.
PostgreSQL 8.4 syntax is much richer than that of MySQL. The former can use the analytic functions, recursive CTE's and proprietary syntax extensions, all of which can be used for this task.
Let's create a sample table:
Read the rest of this entry »
Subscribe in a reader