/ Published in: SQL
Find duplicates in Sql Server.
Expand |
Embed | Plain Text
SELECT [Type], Reference, COUNT(*) FROM Scheme GROUP BY [Type], Reference HAVING COUNT(*) > 1
Comments
Subscribe to comments
You need to login to post a comment.

Can you post an example from this one?
What does the [Type] means?