Select duplicated rows

SELECT field_name, COUNT(*) c FROM table_name GROUP BY field_name HAVING c > 1;

3 Responses

This works in all dbs?
@kim yep. just change `field_name` and `table_name` to your values
@Andrey Romanov thanks :)

Write a comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.