SQL Query to get the list of terminated employees

 select    "PER_PERIODS_OF_SERVICE"."LAST_UPDATE_DATE" as "LAST_UPDATE_DATE",
               "PER_PERIODS_OF_SERVICE"."LAST_UPDATED_BY" as "LAST_UPDATED_BY",
               "PER_ALL_PEOPLE_F"."PERSON_NUMBER" as "PERSON_NUMBER"
 from    "FUSION"."PER_ALL_PEOPLE_F" "PER_ALL_PEOPLE_F",
              "FUSION"."PER_PERIODS_OF_SERVICE" "PER_PERIODS_OF_SERVICE"
 where   "PER_PERIODS_OF_SERVICE"."PERSON_ID"="PER_ALL_PEOPLE_F"."PERSON_ID"
order by "PER_PERIODS_OF_SERVICE"."LAST_UPDATE_DATE" DESC

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Technical Contents - SQL Query
Posted by : Mohammad
Follow on Linkedin