SQL语句可以这样写:这里用student表来做示例: select name from student group by name having count(*) > 1; select id, name from student where name in (select name from student group by name having count(*) > 1); 做了二次查询。
4 1

相关推荐

牛客网
牛客企业服务