mysql根据多个字段去重并保留最小id的记录

最新推荐文章于 2024-07-21 03:31:20 发布

weixin_47766381

最新推荐文章于 2024-07-21 03:31:20 发布

阅读量733

点赞数

分类专栏： mysql java 文章标签： mysql 数据库 database

本文链接：https://blog.csdn.net/weixin_47766381/article/details/123396649

版权

java 同时被 2 个专栏收录

18 篇文章 1 订阅

订阅专栏

mysql

6 篇文章 0 订阅

订阅专栏

mysql根据多个字段去重并保留最小id的记录

友联: https://blog.csdn.net/qq_36530221/article/details/104753964

一: mysql

update table set deleted = 1 where (column1,column2,column3) 
 
in 
 
(select t1.column1,t1.column2,t1.column3 from (select column1,column2,column3 from table group by column1,column2,column3 having count(*) > 1) t1) 
 
and id not in
 
(select t2.minid from (select min(id) minid from table group by column1,column2,column3 having count(*) > 1) t2)

二: java8 特性

List<User> collectList = list.stream().collect(Collectors.collectingAndThen(Collectors.toCollection(() ->
        new TreeSet<>(Comparator.comparing(u -> u.getName() + ";" + u.getAge() + ";" + DateFormatUtils.format(u.getCreateTime(), "yyyy-MM-dd")))), ArrayList::new));