Re: [GENERAL] last entry per person

2012-02-13 Thread Jasen Betts
On 2012-02-03, garry 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

Re: [GENERAL] last entry per person

2012-02-03 Thread garry
On 03/02/2012 08:30, Chris Travers wrote: On Fri, Feb 3, 2012 at 12:26 AM, garry > 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

Re: [GENERAL] last entry per person

2012-02-03 Thread Philip Couling
On 03/02/2012 08:30, Chris Travers wrote: On Fri, Feb 3, 2012 at 12:26 AM, garry > 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

Re: [GENERAL] last entry per person

2012-02-03 Thread Andreas Kretschmer
garry 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. M

Re: [GENERAL] last entry per person

2012-02-03 Thread Chris Travers
On Fri, Feb 3, 2012 at 12:26 AM, garry 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