• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• This code always you to locate duplicates in SQL Server It has been tested using SQL Server 2000. I

This code always you to locate duplicates in SQL Server It has been tested using SQL Server 2000. I

This code always you to locate duplicates in SQL Server It has been tested using SQL Server 2000. It should work with all versions

Rate This code always you to locate duplicates in SQL Server It has been tested using SQL Server 2000. I

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

select * from [Table Name] where [Column Name] in( select [Column Name] from
[Table Name] group by [Column Name]having Count(*) > 1)


Example:
select * from tbl_lot where lotid in ( select lotid from
 tbl_lot group by lotid having Count(*) > 1)