雅安论坛

标题: mysql查询某个字段中是否有重复的值 [打印本页]

---

作者: 匿名    时间: 2021-4-5 11:09
标题: mysql查询某个字段中是否有重复的值

1. SELECT *
   
2. FROM (
   
3. 
   
4. SELECT `ldhm` , COUNT( * ) AS c
   
5. FROM cb_jtjl
   
6. GROUP BY `ldhm`
   
7. )t
   
8. WHERE c >1

复制代码

---

欢迎光临 雅安论坛 (https://www.yaanbbs.net/)

Powered by Discuz! X3.4