Select duplicates from postgres table
March 11, 2022
select sec_id, metric_name, value, date, count(*)
from file_reader_service.jpm_analytics
group by sec_id, metric_name, value, date
HAVING count(*) > 1March 11, 2022
select sec_id, metric_name, value, date, count(*)
from file_reader_service.jpm_analytics
group by sec_id, metric_name, value, date
HAVING count(*) > 1