Re: last entry per person

On 2012-02-03, garry <garry@scholarpack.com> wrote:
> This is a multi-part message in MIME format.
> --------------060709070909070009090305
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> Content-Transfer-Encoding: 7bit
>
> I have a table which holds a user name and their results in exams. There
> can be multiple entries per user. I am trying to return the last entry
> for each user. I can get the last entry in the table using the order
> by/limit method but how would this be applied per user. My table
> definition is like the following:
>
>> gradeid serial primary key,
>> user text,
>> grade char(1),
>> entered timestamp,

select distinct on (user) * from EXAMS order by entered desc;

--
⚂⚃ 100% natural