在db2中，如何根据两个字段把重复的记录select出来？？？

[qish]

高手救救我

[sjsky]

SELECT DISTINCT C_BK_GROUP, C_BK_NAME FROM EXIMMETA.ECD_GROUP
C_BK_GROUP 和 C_BK_NAME 为重复字段

[qish]

我是说把重复的记录选出来，你这样的话根本不行

[m505]

db2 "select * from test, (select a,b,count(*) from test group by a,b having count(*)>1) as temp where test.a=temp.a and test.b=temp.b"

[m505]

select test.*...

[googe]

select a,b from tb1 group by a,b having count(1)>1