:::tip{title="提示"}
查询mysql某字段重复出现的数据
:::




> 查询gCode重复的所有记录，显示所有字段

```
select * from basshoppingguide where gCode in (
    select gCode   from basshoppingguide GROUP BY gCode having count(gCode)>1
    );
```


> 查询gCode重复的所有记录，显示所有字段
```
 
    select gCode,count(gCode) as a   from basshoppingguide GROUP BY gCode having a>1;
    
```

mysql 查询重复数据

首页

分类