Guys how do i select a duplicated field in sql. I have a table with possible duplicates by title, how to select them?
Asked
Active
Viewed 243 times
0
-
2http://stackoverflow.com/questions/2112618/finding-duplicate-rows-in-sql-server – rcorbellini Apr 15 '13 at 18:52
1 Answers
2
You can use this:
SELECT title, COUNT(*) as titleCount
FROM yourTableName
GROUP BY title
HAVING COUNT(*) > 1
Lawson
- 624
- 1
- 5
- 19
-
+1 . . . This is a very reasonable answer given the details in the question. This is, however, standard SQL and should work in any database. – Gordon Linoff Apr 15 '13 at 19:28
-