Fetching last manager name and number for the terminated employees in sql

Summary

Fetching last manager name and number for the terminated employees in sql

Content

Hi,

 

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.

Nirmal kumar