Fetching last manager name and number for the terminated employees in sql
SummaryFetching last manager name and number for the terminated employees in sql
Anyone know how to fetch the manager name for the terminated employees? For terminated or resigned employees manager name and number wont be there in application. But our customer requirement is to fetch the manager details for them. They want to capture his/her manager name before he resigned. How to fetch that in sql?
Thanks in advance. Need your inputs.