题目:
在user表中,查出name属性值重复2次以上的记录数据。
答:
select * from user t where t.name in (select name from user group by name having count(name) > 1);
如:
现在就是需要查询出在该表中的各记录之间,“name”值存在重复的项;
Select Name,Count(*) From A Group By Name Having Count(*) > 1
如果还查性别也相同大则如下:
Select Name,sex,Count(*) From A Group By Name,sex Having Count(*) > 1