Re: last entry per person

On Fri, Feb 3, 2012 at 12:26 AM, garry <garry(at)scholarpack(dot)com> wrote:

> 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,
>>
> Any help would be appreciated.
> Regards

What about a combination of a common table expression and a windowing
function? You ought to be able to order by your criteria and then pull
where the rowcount in the window is 1.

Best Wishes,
Chris Travers

>
> Garry
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>