Bom dia Francisco... Acho que isto deve resolver...
select cod_documento
from contas_pagar_an
group by cod_documento
having count( cod_documento ) > 1
Ernani
"Francisco Frank" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
30/03/2004 07:46
Please respond to sqlwin
To: "SqlWindows" <[EMAIL PROTECTED]>
cc:
Subject: [sqlwin] Registros duplicados
[IMAGE]
Al� pessoal, tenho uma tabela com 97136 registo dentre eles,�alguns
registros est�o duplicados. (tabela sem chave).
Existe alguma instru��o SQL que lista os registros duplicados?
Agrade�o qualquer dica
Francisco Frank
____________________________________________________
[IMAGE]� IncrediMail - O mundo do correio eletr�nico finalmente
desenvolveu-se - Clique aqui
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
Empfaenger sein, so bitten wir hoflich um eine Mitteilung. Jede
unbefugte Weiterleitung oder Fertigung einer Kopie ist
unzulaessig. Diese Nachricht dient lediglich dem Austausch von
Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails konnen wir
keine Haftung fur den Inhalt ubernehmen.
This message is confidential and may be privileged. If you are not
the intended recipient, we kindly ask you to inform the sender.
Any unauthorised dissemination or copying hereof is prohibited.
This message serves for information purposes only and shall not
have any legally binding effect. Given that e-mails can easily be
subject to manipulation, we can not accept any liability for the
content provided.
==============================================
Lista de Centura SQLWindows
Administrador : [EMAIL PROTECTED]
[ http://www.centuraexplorer.com ]
Para sair desta lista mande mensagem para:
[EMAIL PROTECTED] sem nada no Subject e
com o comando a seguir no corpo da msg:
"unsubscribe sqlwin" (sem as aspas)
==============================================
