from a in HostLog
group a by a.HostInfoID into grp
let maxModifyTime = grp.Max(a => a.ModifyTime)
from row in grp
where row.ModifyTime == maxModifyTime
select row;