SELECT YourTable.* from YourTable inner JOIN (SELECT YourTable.Id, YourTable.DateSaved max(YourTable.TimeSaved) as MaxTime FROM YourTable INNER JOIN (SELECT Id, MAX(DateSaved) AS DateSaved FROM YourTable GROUP BY Id) Tbl1 ON YourTable.Id = Tbl1.Id AND YourTable.DateSaved = Tbl1.DateSaved) group by 1,2) sql ; on YourTable.ID = sql.ID and YourTable.DateSaved = sql.DateSaved and YourTable.TimeSaved = sql.MaxTimenot tested and there could be better ideas, of course.
>Sn Bal DateSaved TimeSaved >1 200 2/5/2008 10:00 >1 175 2/5/2008 11:00 >1 123 2/5/2008 13:00 >1 111 2/6/2008 08:00 >1 101 2/6/2008 18:00 >2 500 2/8/2008 10:00 >2 475 2/8/2008 11:00 >>
>Sn Bal DateSaved TimeSaved >1 101 2/6/2008 18:00 >2 475 2/8/2008 11:00 >>