I'm trying to use the query below. What happens is that call_id can get many duplicates. I'm trying to get the latest call_id based in received_date of there are dupes. As well as getting any data that is not a dupe.
select received_date, call_id, COUNT(call_id)
group by received_date, call_id
having COUNT(call_id) > 1
order by COUNT(call_id) des