If there are 2 records for an Employee, How can I choose the one with eff_status = �Active' and ignore the eff_status ='Terminated'. if there is only one record, then just write that record regardless of the eff_status.
Please assist.
provide us the input, expected output and the code you have tried so far?