How to use group by in this situation

[varunreddy]

Hi,

I have data in this format

I need maximum date by ID.

i.e. For ID = 1, Date = 3/1/2016

For ID = 2, Date = 5/1/2016

For ID = 3, Date = 6/1/2016

Is there a way I can get this?

Thanks in advance!

Cheers,

Varun

[martinpohl · Accepted solution]

hello,

use this:

left join (your data) load

ID,

max(Date) as MaxDate

resident your data

Group by ID;

Regards

[varunreddy]

Martin,

Thanks for your quick response.

Cheers,

Varun