postgresql 删除重复数据
tion by bill_id,account_book_id order by id desc) as rank from bill_account_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';
[/code]
原创
2019-01-26 01:19:47 ·
569 阅读 ·
0 评论