Need help getting rid of duplicated data based off a certain column in SELECT
I need to perform a SELECT SQL query. The issue is that there is a column (publicId
) that can have duplicate values. If duplicates exist, I need to keep only the most recent results based on the dateAdded
column in the table.