mysql查询表某些字段完全相同的数据

//如果表中有特殊的查询条件 比如下面查询中 要求 表中article_number is not null

select t.product_id,t.cols8,t.cols9,COUNT(product_id) As Account,COUNT(cols8) As Account2 ,COUNT(cols9) As Account3 
from(select product_id,cols8,cols9 from tbl_mall_spec_data WHERE article_number is not null) t  
group by product_id,cols8 ,cols9
HAVING Account>1 and Account2>1 and Account3>1;

//如果没有任何条件

select product_id,cols8,cols9,COUNT(product_id) As Account,COUNT(cols8) As Account2 ,COUNT(cols9) As Account3 
from tbl_mall_spec_data 
group by product_id,cols8 ,cols9
HAVING Account>1 and Account2>1 and Account3>1;

字段可以添加多个，此处按照三个来算