UNIQUE VALUE WITH MAX DATE

[2009luca]

I have in a atable:

FIELD1 FIELD2
AAAA 01/01/2016
AAAA 13/03/2016
BBBB 01/03/2016
...

I need with, a sql, to exctract a unique records in field1 based the max date in field2...

result for me:
AAAA 13/03/2016
BBBB 01/03/2016


note:
i use ADO and vb6

 

[Andrzejek]

Select FIELD1, MAX(FIELD2) As FIELD2
From atable
Group By FIELD1

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.