postgres重复数据只保留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);