Re: How To List Duplicate Records ?..

From: Alexander Romanov <sashar_at_comita.spb.ru>
Date: Wed, 7 Jul 1999 15:10:33 +0400
Message-ID: <7lvcp5$96a$1@dragon.infopro.spb.su>

Hi Angelica

select distinct a.cust_id,b.cust_num from customer a,customer b where a.cust_num=b.cust_num and not a.cust_id = b.cust_id;

You receive Cust_ID with duplicated records Cust_Num

Angelica Veron ïèøåò â ñîîáùåíèè <378281FC.FF6D8701_at_globalserve.net> ...
> This table was recently created, and I need to check for the
>existance of records with differing CUST_ID's but have the same
>CUST_NUM. Overall, I need to locate all records which have the same
>CUST_NUM, but different CUST_ID's , and the CUST_CURRENT_FLAG has to
>equal 'Y' (meaning they are current). Does anyone know which query will
>list such duplicate records for me ??... any help would be greatly
>appreciated, thank you for your time.

Best regards
Всех Благ
---
Origin ... Просто надо очень верить этим синим маякам... Romanov Alexander
Alex_Romanov_at_mail.ru
ICQ 6220754 Received on Wed Jul 07 1999 - 06:10:33 CDT