Re: CHECK DOUBLE RECORD

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 12:46:34 +0530

see following example:

create table test(c1 varchar(10), c2 varchar(10), c3 char(1))

insert into test values('50000A','123456','A')
insert into test values('50000A','654321','A')
insert into test values('50000X','654321','A')

query:
select a.*
from test a join (Select c1,c3 from test group by c1,c3 having count(*) >
1) b
on a.c1 = b.c1 and a.c3=b.c3 

-- 
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com