MySQL 查找重复值

来源:互联网 发布:华为麦芒4钢化膜淘宝 编辑:程序博客网 时间:2024/05/17 22:23

从 users 表中查找 name 重复的项

select name, count(*) as count from users group by name order by count DESC;

select name, count(*) as count from users group by name order by count DESC limit 20;


0 0
原创粉丝点击