You should try this, A simplest way to resolve your query

Select t1.Person, max(isnull(t1.UpdatedDate, getdate())) from Table1 t1 group by t1.Person;

using "having" clause to filter the data

Thanks By:-

web designing in...