Re: [SQL] Most recent row - Mailing list pgsql-sql

From Gary Stainburn
Subject Re: [SQL] Most recent row
Date
Msg-id 201705081249.33815.gary.stainburn@ringways.co.uk
Whole thread Raw
In response to Re: [SQL] Most recent row  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-sql
On Friday 05 May 2017 12:09:39 hubert depesz lubaczewski wrote:
> There was this part, but it still doesn't contain information about:

To clarify the current situation

> - how many assessments per person will there usually be?
There will be roughly one assessment per person every 6 months, so initially 
the count will be low, but will increase over time. As we are still to 
implement this, the assessment count is zero, although many of the 
assessments have already been done on paper. Once up to date, everyone should 
have at least once assessment.

> - will you always get data for all people?
When a new person is added he will not have an assessment.

> - if not (all people) - how many (percent or count)?

Once each person has been added, an assessment wil be scheduled for as quickly 
as possible. As we currently have 720 people, adding 7 more people is only 1% 
so I should say the percentage will be between 0% and 1%

(Once up to date)



pgsql-sql by date:

Previous
From: Bob Edwards
Date:
Subject: Re: [SQL] Most recent row
Next
From: Thomas Kellerer
Date:
Subject: Re: [SQL] Most recent row