Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;