Loading just the max record in each group

richard_chilvers — Thu, 28 Mar 2013 11:47:23 GMT

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.

Re: Loading just the max record in each group

Gysbert_Wassenaar — Thu, 28 Mar 2013 11:51:25 GMT

Left join it with the load of all fields:

load Index, max(date) as date from table group by Index;

left join load Index, date, field1, field2 from table;