Re: [SQL] Most recent row

On 2017-05-05 10:25, Gary Stainburn wrote:
> This question has been asked a few times, and Google returns a few 
> different
> answers, but I am interested people's opinions and suggestions for the 
> *best*
> wat to retrieve the most recent row from a table.
> 
> My case is:
> 
> create table people (
>   p_id  serial primary key,
>  ......
> );
> 
> create table assessments (
>   p_id    int4 not null references people(p_id),
>   as_timestamp    timestamp not null,
>   ......
> );
> 
> select p.*, (most recent) a.*
>   from people p, assessments a
>   ..
> ;

It depends on what you mean by 'most recent'. Do you mean "the row I 
just inserted" or "the row with a date closest to now()" or perhaps some 
other definition?