Re: SQL query question

From: John Cunningham <shortseller12_at_yahoo.com>
Date: 16 Apr 2003 11:46:39 -0700
Message-ID: <9f8bd1ef.0304161046.5c8e166c@posting.google.com>

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<36oo9v4cnmb591j48p5o6g0pd4a8fqe3bl_at_4ax.com>...
>
> Better
> select *
> from rates r
> where efct_date =
> (select max(efct_date)
> from rates r1
> where r1.city = r.city
> )
>
>
> Sybrand Bakker, Senior Oracle DBA
>

Thanks Sybrand, that worked just fine.

Thanks to the others too. Received on Wed Apr 16 2003 - 13:46:39 CDT