Re: Selecting table row with latest date - Mailing list pgsql-general

On Thu, 19 Aug 2021, Tom Lane wrote:

> The best way is usually like
>
>    select * from mytable order by contact_date desc limit 1;
>
> If you have an index on contact_date this should work very well indeed.

Tom,

I don't have an index on that table. I'll add one and try you suggestion.

Thanks,

Rich