Select 
	t.CustId 
	,t.PersonId 
	,t.startdate 
	,t.Enddate 
	,t.Name 
from 
	(
		Select 
			CustId 
			,PersonId 
			,startdate 
			,Enddate 
			,Name
			,ROW_NUMBER() OVER(PARTITION BY PersonId ORDER BY Enddate DESC) as rownum
		from		
			table1
	) as t
where
	t.rownum=1