http://weblogs.asp.net/akbar/archive/2008/09/11/simple-sql-query-to-get-duplicate-values-in-a-table.aspxThis is simple T-SQL query to find duplicate values in Microsoft SQL Server Database select a.field1, a.field2,a.field3, a.field4 from table a where 1 from table b where b.field1 = a.field1 and b.field2 = a.field2 and b.field3 = a.field3)enCommunityServer 2007 SP1 (Build: 20510.895)