hi,

I've problem to check row which having duplicate value
for fieldA and fieldC.

Eg.

rec 1
fieldA fieldB fieldC
50000A 123456 A
rec 2
50000A 654321 A

Thanks.

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