Postgres Pro
Downloads
Home   >   mailing lists

For each key, find row with highest value of other field - Mailing list pgsql-sql

From Raj Mathur
Subject For each key, find row with highest value of other field
Date
Msg-id 200810040025.31398.raju@linux-delhi.org
Whole thread Raw
Responses Re: For each key, find row with highest value of other field  ("Fernando Hevia" <fhevia@ip-tel.com.ar>)
Re: For each key, find row with highest value of other field  (Mark Roberts <mailing_lists@pandapocket.com>)
List pgsql-sql
Tree view 
I have some data of the form:

Key | Date       | Value
A   | 2008-05-01 | foo    *
A   | 2008-04-01 | bar
A   | 2008-03-01 | foo    *
B   | 2008-03-04 | baz
B   | 2008-02-04 | bar
C   | 2008-06-03 | foo    *
C   | 2008-04-04 | baz
C   | 2008-03-04 | bar

Is there any way to select only the rows marked with a (*) out of these 
without doing a join?  I.e. I wish to find the row with the highest 
Date for each Key and use the Value from that.

Regards,

-- Raju
-- 
Raj Mathur                raju@kandalaya.org      http://kandalaya.org/      GPG: 78D4 FC67 367F 40E2 0DD5  0FEF C968
D0EFCC68 D17F
 
PsyTrance & Chill: http://schizoid.in/   ||   It is the mind that moves

pgsql-sql by date:

Previous
From: "Marc Mamin"
Date:
Subject: Re: Query how-to
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: For each key, find row with highest value of other field