How do I remove duplicate SQL records, leaving only one by most recent date?
I need to create a SQL View that removes duplicate records. Right now when I run the query, it is pulling in all records and I want it to only pull up the most recently updated record.
The SQL View name is: FM_Report and it is pulling info from two Tables: FM_Project and Project_Status_History
-- I want to remove all duplicate records sharing the same: SBBC_Project_Number (found in both tables)
-- I want to leave just the most recent record by the most recent update: Project_Status_Date (found in the Project_Status_History table)