Re: [GENERAL] last entry per person

[garry]

On 03/02/2012 08:30, Chris Travers wrote:


On Fri, Feb 3, 2012 at 12:26 AM, garry <ga...@scholarpack.com 
<mailto: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.


Unfortunately I am using a version of postgres without the windowing 
functions, but that would have done the job.
Regards
Garry
<<attachment: garry.vcf>>-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general