Hi

CURSOR X IS
SELECT a.personid, a.title, a.date_started, a.date_finished
FROM hr_table a, ( Select personid, max(date_finished) date_finished from hr_table GROUP BY personid) b
WHERE a.personid=b.personid AND a.date_finished = b.date_finished

This query will work. It will not have the overhead as equivalent to correlated sub-query. But dunno if u will like it !

HTH.

Cheers
Nandu