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)
转载于:https://www.cnblogs.com/lhuser/articles/2074981.html