Re: newbie question for return date - Mailing list pgsql-general

In article <xEgv9.2668$h_4.374526@news20.bellglobal.com>, tviardot wrote:
> Hi guys, here a newbies question.
> I've made a table with some action and date.
> How may i query the most recent date. (I'd like to return only the record
> which have the most recent date ).
> Tx
>
>

How about:

SELECT * FROM t ORDER BY d DESC LIMIT 1;