last entry per person - Mailing list pgsql-general

From garry
Subject last entry per person
Date
Msg-id 4F2B9A2F.3060205@scholarpack.com
Whole thread Raw
Responses Re: last entry per person  (Chris Travers <chris.travers@gmail.com>)
Re: last entry per person  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-general
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
Garry


Attachment

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Understanding EXPLAIN
Next
From: Chris Travers
Date:
Subject: Re: last entry per person