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