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