On 2012-02-03, garry <ga...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
