weixin_43429567的博客

原创 SQL 列出重复次数和 重复的字段

文章目录select count(*) as repeat_count,name from "数据表" group by name having repeat_count > 1; select count(*) as repeat_count,name from “数据表” group by name having repeat_count > 1; ...