id visit_ date Name 123 11/6/2015 3:17:22 PM abc 123 11/6/2015 3:24:44 PM abc 456 11/6/2015 3:26:34 PM def 456 11/6/2015 3:30:34 PM def
id visit_ date Name 677930136v 11/6/2015 3:24:44 PM abc 906080275v 11/6/2015 3:30:34 PM def
GROUP BY
SELECT id, visit_date, Max(Name) As Name FROM YourTable GROUP BY id, visit_date ;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)