mysql查询某个字段中是否有重复的值

方法一

SELECT *
FROM (

SELECT `VirtualMachineName` , COUNT( * ) AS c
FROM AzureVirtualMachine
GROUP BY `VirtualMachineName`
)t
WHERE c >1

方法二

SELECT ziduan ,
        COUNT(ziduan)
FROM  biaoming
GROUP BY ziduan
HAVING  COUNT(ziduan) > 1

 

-- biaoming 是表名

-- ziduan 是要确定是否有重复值的字段