Interview QuestionsCategory: MySQLHow to fetch duplicate records in mysql?
bestonetechnologies Staff asked 2 years ago

How to fetch duplicate records in mysql?

1 Answers
bestonetechnologies Staff answered 2 years ago

select * from user where id in(
SELECT id from user group by name having count(id) > 1
)

Princy replied 4 months ago

Great, Thanks it helps me lot.

Your Answer

5 + 1 =