Re: find all latest value = 'X'

You may try this:

select a.personid, a.ratingdate
from rating_table a
where a.rating = 'A'
and not exists (

   select null
   from rating_table b
   where b.person_id = a.person_id
   and b.ratingdate > a.ratingdate)
/

-- 

William WW LEE.
E-Mail: william_at_alumni.cuhk.edu.hk
***********************************