SQL语句 检查重复记录的字段名
select 字段名,count(字段名) from 表名 group by 字段名 having count(字段名)>1
SELECT VWS, COUNT(VWS) AS Expr1
FROM EsBom
GROUP BY VWS
HAVING (COUNT(VWS) > 1)
select 字段名,count(字段名) from 表名 group by 字段名 having count(字段名)>1
SELECT VWS, COUNT(VWS) AS Expr1
FROM EsBom
GROUP BY VWS
HAVING (COUNT(VWS) > 1)