Hi All,

I have a problem which everybody is discussing.

I need to find the duplicate record in the table. Its not a matter of just 1 column.

create table #temp

(ddatetime datetime ,

co1 int ,

col2 int )

Insert into #temp

values ('2001-11-12 13:29:00.000' , 101 , 15)

Insert into #temp

values ('2001-11-12 13:45:00.000' , 102 , 15)

Insert into #temp

values ('2001-11-12 13:50:49.000' , 101 , 15) [duplicate] 😎

Insert into #temp

values ('2001-11-12 13:50:49.000' , 101 , 15) [duplicate] 😎

Insert into #temp

values ('2001-11-12 14:00:49.000' , 101 , 15)

Insert into #temp

values ('2001-11-12 14:00:49.000' , 102 , 15)

Insert into #temp

values ('2001-11-12 14:00:49.000' , 103 , 15)

I have to find the duplicate value with the combination of the 3 columns.

Please help