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

    Loading just the max record in each group

    Richard Chilvers



      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 ?