怎样查询一张表里面的某个字段是否有重复值,该如何解决

select count(1), your_field from your_table group by your_field having count(1) > 1
------解决方案--------------------
SQL code
 select count(字段),money from 表明 group by 字段 having count(字段) >1;select count(money),money from t_financialinfo group by money having count(money) >1;