Postgres Pro
Downloads
Home   >   mailing lists

How to select rows that are the max for each subcategory? - Mailing list pgsql-general

From Kynn Jones
Subject How to select rows that are the max for each subcategory?
Date
Msg-id c2350ba40809251101y81de3f8qb0e5daafeaad240f@mail.gmail.com
Whole thread Raw
Responses Re: How to select rows that are the max for each subcategory?  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
Re: How to select rows that are the max for each subcategory?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Suppose I have a table T that has, among its columns, the fields X and Y, where Y is an integer, and multiple rows with the same value of X are possible.  I want to select the rows corresponding to the greatest values of Y for each value of X.  E.g. suppose that T is

X Y Z
a  1 eenie
a  3 meenie
a  2 miny
b  4 moe
b  0 catch

...the result of the desired query would be

a  3 meenie
b  4 moe

TIA!

Kynnjo



pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: Dynamically created cursors vanish in PLPgSQL
Next
From: "Harald Armin Massa"
Date:
Subject: Re: How to select rows that are the max for each subcategory?