Re: [SQL] Most recent row

On Fri, May 05, 2017 at 09:25:04AM +0100, 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
>   ..
> ;

You will need to provide a definition for *exactly* what
"most recent" means in this context.

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346