delete [table]
    from [table] as t left outer join
    ( select top 100 percent [name], [date], min([time]) as [time]
        from [table]
        group by [name], [date]
        order by [name]
    ) as tt on tt.[name] = t.[name] and tt.[date] = t.[date] and tt.[time] = t.[time]
    where tt.[name] is null