Where do you see the second table in it? I guess here:
A = mytable B = (select field1, field2, count(*) from mytable group by field1, field2 having count(*) > 1) So that is all around one table that is 'mytable', where A and B are just the aliases. -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 2/2/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
Thank you but are you talking of two tables ? I intent to check in only one table. Please explain to me. Ezequias 2007/2/2, Bart Degryse < [EMAIL PROTECTED]>: > > select * > from mytable A, (select field1, field2, count(*) from mytable group by > field1, field2 having count(*) > 1) B > where A.field1 = B.field1 and A.field2 = B.field2 > > >>> "Ezequias Rodrigues da Rocha" < [EMAIL PROTECTED]> 2007-02-02 > 14:48 >>> > Hi list, > > I am making some data minning and would like to know if someone tell me > how to retrieve the duplicate records based in one or two fields of my > table. > > Any help would be welcomed. > > -- > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Atenciosamente (Sincerely) > Ezequias Rodrigues da Rocha > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > A pior das democracias ainda é melhor do que a melhor das ditaduras > The worst of democracies is still better than the better of > dictatorships > http://ezequiasrocha.blogspot.com/ > -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- A pior das democracias ainda é melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/
