Interview QuestionsCategory: MySQLHow to fetch duplicate records in mysql?
bestonetechnologies Staff asked 1 year ago

How to fetch duplicate records in mysql?

1 Answers
bestonetechnologies Staff answered 1 year ago

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

Your Answer

11 + 14 =