Posted By

andylamb on 02/21/13


Tagged

sql server duplicate find


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

chasday


Find Duplicates in SQL


 / Published in: SQL
 

Find duplicates in Sql Server.

  1. SELECT [Type], Reference, COUNT(*)
  2. FROM Scheme
  3. GROUP BY [Type], Reference
  4. HAVING COUNT(*) > 1

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: merlyn333 on March 7, 2013

Can you post an example from this one?

Posted By: merlyn333 on March 7, 2013

What does the [Type] means?

You need to login to post a comment.