Re: SQL question - most recent value for each group of data
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Fri, 29 Feb 2008 09:24:28 +0200
Message-ID: <6e49b6d00802282324v1fd9360dhb419c2b8e4c1d43@mail.gmail.com>
Date: Fri, 29 Feb 2008 09:24:28 +0200
Message-ID: <6e49b6d00802282324v1fd9360dhb419c2b8e4c1d43@mail.gmail.com>
There was a recent thread in CDOS about similar problem. You can check it here
http://groups.google.ca/group/comp.databases.oracle.server/browse_frm/thread/638207c27f61c4e5/69806e657286ce57#69806e657286ce57
Gints Plivna
http://www.gplivna.eu
2008/2/29, Reardon, Bruce (RTABBAY) <Bruce.Reardon_at_riotinto.com>:
> I have a case where I need to return the most recent record for each
> group of data and I'm interested in how to do most efficiently.
>
> Versions - Oracle 8.1.7.4 on Windows 2003R2 SP2
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 29 2008 - 01:24:28 CST