Query to find recent payroll action
Summary
Query to find recent payroll actionContent
For a particular employee, on the same day, they have processed payroll actions such as "Regular Normal" once and "Process separately" twice. Is anyone aware of how I can get the last payroll action that happened. In my sample, Process separately only happened at last, so I want my query to return the last processed process separately action only.
I was able to display the expected process separately action by sorting the Payroll rel action ID column in descending, the latest payroll action was at top when i sorted the payroll rel action id in descending, but I would like to confirm if this is right or any other approach is available in SQL to find the recent payroll action