postgresql 删除重复数据

最新推荐文章于 2024-10-04 07:22:19 发布

麻辣小布叮

最新推荐文章于 2024-10-04 07:22:19 发布

阅读量539

点赞数

分类专栏： Postgresql 文章标签：数据库

本文链接：https://blog.csdn.net/luobing_csdn/article/details/88341587

版权

Postgresql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

set statement_timeout=0;
explain analyze
delete From book_detail a where a.id = any(array (
select id from (
select id,bill_id,account_book_id, row_number() over(partition by bill_id,account_book_id order by id desc) as rank from book_detail 
where sell_date BETWEEN '2018-12-01' and '2018-12-31' 
) a where a.rank > 1
)
) and a.sell_date BETWEEN '2018-12-01' and '2018-12-31';