SELECT *
FROM PersonRecord A
       INNER JOIN PersonRecord B
                ON A.PersonID = B.PersonID
                AND A.VersionID = B.VersionID - 1
WHERE B.DEDate > A.DEDate