Hi,

It=B4s something like:

SELECT ID_CLIENT, LAST_NAME, COUNT(LAST_NAME) FROM TBL_CLIENT HAVING
COUNT(LAST_NAME) > 1 GROUP BY ID_CLIENT, LAST_NAME

I hope it works.

Best regards,

Juliano Moraes Rodrigues
Analista de Sistemas - FA Consult
juliano.rodrigues@f...
(019) 9719-2417
S=E3o Paulo - Brasil


-----Mensagem original-----
De: Ryan Lockhart [mailto:rlockhart@p...]
Enviada em: quarta-feira, 12 de setembro de 2001 13:58
Para: sql language
Assunto: [sql_language] Weeding out Duplicates


How can I get a list of duplicate records in a database?  Say I want a 
to
see all the records with the same last name, what would the sql query 
look
like?