Finding duplicates with SQL? SQL Server by admin - February 15, 2013June 14, 20140 Suppose Col1 is the field name for which you want to find duplicates: Select Col1, Count(Col1) as count from table1 group by Col1 having Count(Col1) > 1 Get Free Email Updates!Signup now and receive free offers, discounts & coupon codes I agree to have my personal information transfered to Mad Mimi ( more information ) I will never give away, trade or sell your email address. You can unsubscribe at any time. Related PostsFormatting DateTime to Date in SQL SERVERDifference between Stored Procedures and ViewsRounding a number to 2 decimal places in SQL SERVEREnable ASP.NET errors on Remote ServerTop 20 Replies by Programmers when their programs don’t workDelete all rows of a table in JQuery except first row20+ Best WordPress Affiliate Themes Available Online5 Best Free Website to PDF Converters301 Redirect in classic ASPThe Importance Of A Good Website DesignUsing Like in LINQfatal error C1189: #error : This file requires _WIN32_WINNT to be #defined at least to 0x0500. Value 0x0501 or higher is recommended.