Re: Selecting table row with latest date

[Rich Shepard]

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