delete from t_openapi_baseindex_week where ctid not in (select max(ctid) from t_openapi_baseindex_week group by
area_code,
area_name,
YEAR,
week,
TYPE,
time_type,
is_workday having count(*) >1);
delete from t_openapi_baseindex_week where ctid not in (select max(ctid) from t_openapi_baseindex_week group by
area_code,
area_name,
YEAR,
week,
TYPE,
time_type,
is_workday having count(*) >1);