Duplicate records

Hi list,<br /><br />I am making some data minning and would like to know if someone tell me how to retrieve the
duplicaterecords based in one or two fields of my table.<br /><br />Any help would be welcomed.<br clear="all" /><br
/>--<br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=<br
/>                                  Atenciosamente(Sincerely)<br />                        Ezequias Rodrigues da
Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- <br />A pior das democracias ainda
émelhor do que a melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships<br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/ </a>