1 Reply Latest reply: Mar 28, 2013 7:51 AM by Gysbert Wassenaar RSS

    Loading just the max record in each group

    Richard Chilvers

      Hi

       

      This seems a simple issue, but I cannot find the solution on here !

       

      My table has the following fields per record:

       

      Index, date, field1, field2

       

      For each value of Index, I want to load just the record with MAX(date).

       

      I believe   LOAD Index, MAX(date) from table group by Index    would work.

       

      But how do I include field1 and field2 ?

       

      Thanks.