On Fri, Feb 3, 2012 at 12:26 AM, garry <ga...@scholarpack.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > >
