Need a SQL statement that eliminates duplicates and chooses the last record entered.
Ex. WO1002421 has two entries. I want to keep the record of the last person Wilmer Tamayo-Sanchez.
This statement below is what I am using but as unfortunately, it still brings in duplicates.
SELECT MAX(WO_NUMBER) as wo_number
WHERE SKILL NOT LIKE '%INSPECTOR'
GROUP BY WO_NUMBER
ORDER BY WO_NUMBER