怎么查重复数据

如何查重复数据
A表中有MB001,MB002....MB030 三十个字段，MB001,MB002,MB003,MB004,MB005组成主件，只要这5个段一样时认定重复
请问应该如何将重复的查询出来

[解决办法]
GROUP BY MB001,MB002,MB003,MB004,MB005 HAVING COUNT(1)>1
[解决办法]

SQL code

select * from A表group by MB001,MB002,MB003,MB004,MB005 having count(1)>1