select * from c_pro_men a where pla_end_dat = (select max(pla_end_dat) from c_pro_men where emp_code = a.emp_code and pro_id=1073) and pro_id = 1073
select * from c_pro_men a where pla_end_dat = (select max(pla_end_dat) from c_pro_men where emp_code = a.emp_code and pro_id=1073) and pro_id = 1073