Could someone point me in the right direction.. Thanks - reid
Given the example data, how do I write a query that will give me the resultset: 1 2011-01-01 2 2011-01-06 3 2011-01-05 4 2011-01-09 5 2011-01-05 6 2011-01-08 I.E. for each distinct val, return the record with the most recent date. ex data val date 1 2011-01-01 2 2011-01-02 3 2011-01-03 4 2011-01-04 5 2011-01-05 5 2011-01-01 4 2011-01-02 6 2011-01-03 4 2011-01-04 3 2011-01-05 2 2011-01-06 4 2011-01-07 6 2011-01-08 4 2011-01-09 5 2011-01-01 2 2011-01-02 4 2011-01-03 2 2011-01-04 1 2011-01-01 2 2011-01-02 3 2011-01-03 4 2011-01-04 3 2011-01-05 1 2011-01-01 2 2011-01-02 3 2011-01-03 4 2011-01-04 5 2011-01-01 ----------------------------------- $ cat sampledata|sort -k1,2 1 2011-01-01 1 2011-01-01 1 2011-01-01 2 2011-01-02 2 2011-01-02 2 2011-01-02 2 2011-01-02 2 2011-01-04 2 2011-01-06 3 2011-01-03 3 2011-01-03 3 2011-01-03 3 2011-01-05 3 2011-01-05 4 2011-01-02 4 2011-01-03 4 2011-01-04 4 2011-01-04 4 2011-01-04 4 2011-01-04 4 2011-01-07 4 2011-01-09 5 2011-01-01 5 2011-01-01 5 2011-01-01 5 2011-01-05 6 2011-01-03 6 2011-01-08 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
