ID NAME DATE 1 TEST-1 2012-1-1 2 TEST-1 2012-4-3 3 TEST-2 2012-2-3 4 TEST-2 2012-6-4
ID NAME DATE 2 TEST-1 2012-4-3 4 TEST-2 2012-6-4
Select * From tablename where ID in(Select Max(ID) From tablename group by name)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)