SELECT *
FROM   emp a
WHERE  rowid > (SELECT Min(rowid)
                FROM   emp b
                WHERE  b.emp_id = a.emp_id
                       AND b.dept_id = a.dept_id
                       AND b.sal = a.sal
                       AND b.dob = a.dob
                       AND ((b.addr_cd = a.addr_cd)
                             OR (b.addr_cd IS NULL
                                 AND a.addr_cd IS NULL))
                       AND b.end_tms IS NULL
                       AND a.end_tms IS NULL);