>>Select policy, exp_mod, eff_date ; >> from mytable mt1 ; >> WHERE NOT EXISTS ( ; >> SELECT * FROM mytable mt2 ; >> WHERE mt2.policy = mt1.policy AND mt2.eff_date > mt1.eff_date) ; >> into cursor xxx >> >>* or >> >>Select policy, exp_mod, eff_date ; >> from mytable mt1 ; >> WHERE eff_date = ( SELECT MAX(eff_date) FROM mytable mt2 ; >> WHERE mt2.policy = mt1.policy) ; >> into cursor xxx >>