Need help with SQL query (OBIEE Dataset)
SummaryBuilding a report showing a persons information on 2 different dates - need help with some sql design (if possible)
I am trying to build a report to show data for an employee on 2 different dates (ie: Data from Jan 1, 2020 and data from Jun 30, 2020)
some fields to be shown are:
location, department, people group, comp group, shift schedule, etc.
I think I have the query to pull the data for the 2 different dates but now I need to only pick up those records where any of the fields have changed
If no change has happened between the 2 dates, then I don't want to show the employee on the report.