Retrieve top 2 records per employee
Summary
Need to figure out a way to determine the top 2 records for an employeeContent
Hi All,
I am read through some posts but still haven't found a solution for what I am trying to do.
I need to create a report that shows an employees Current/Previous Job Code, Job Title, Grade
I have the query to pull in most of the data but with the transactional lines, it was pointed out that I had the incorrect previous record
The users want to see the values from the last time they were different
I am trying to build a query where I have combined the employees Person Number, Job Code, Job title, Grade with Effective Start and End Dates