Re: [SQL] Most recent row

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)