Retrieve top 2 records per employee

Sep 24, 2020 7:55PM

Summary

Need to figure out a way to determine the top 2 records for an employee

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