Re: Max

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 31 Jan 2003 07:30:50 -0800
Message-ID: <a20d28ee.0301310730.35697413@posting.google.com>

Alain <Alain_at_o.fr> wrote in message news:<2003131-12409-671181_at_foorum.com>...
> Hello,
>
> I have :
>
> TX Date
> -- -----
> 3 2002-01-01
> 4 2002-05-01
> 5 2002-03-01
>
> I would like to get TX value where Date is the max date (4 in this sample)
> without using order by desc and selecting the first line...
>
> Thanks in advance.

select tx from foo where date = (select max(date) from foo)

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri Jan 31 2003 - 09:30:50 CST