Hello,
I am trying to return only one row for the same person with mutiple trans codes. For example:
AND INDVBENCVG.TRANS_CD LIKE '8%' and ( indvbencvg.indvbencvg_effdt = ( select max ( b.indvbencvg_effdt ) from indvbencvg b where b.indv_id = indvbencvg.indv_id and INDVBENCVG.EXPDT >SYSDATE ) )
AND ( ( EMPLRDEF_T.NAME1 LIKE 'N%' AND EMPCURRPOSN.BENGRP_CD NOT IN ( '18', '43','44','45', '60','70','71','61','99' ) ) or ( EMPLRDEF_T.NAME1 LIKE 'R%' AND EMPCURRPOSN.BENGRP_CD NOT IN ( '10','14','17','25','41','42' ) ) )
This returns mutiple values for one employee that are different. I do not care what row it returns to me I just want any "ONE" of them.
Example:
11111 8000 N
11111 8060 N
11111 8010 N