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);
postgres重复数据只保留1条数据
最新推荐文章于 2023-05-09 16:12:43 发布