查询数据表中的重复数据
场景:有一个数据表member,结构如下:
表中数据如下:
要求查询member表中name重复的数据,sql语句为:
select a.id,b.name from member as a,member as b where a.name=b.name and a.id<>b.id;
结果如下图:
场景:有一个数据表member,结构如下:
表中数据如下:
要求查询member表中name重复的数据,sql语句为:
select a.id,b.name from member as a,member as b where a.name=b.name and a.id<>b.id;
结果如下图: