How to get duplicates from a table?

Question

Laravel

The interests tab contains many identical entries:
id | user_id | name
1 | 1 | test
2 | 1 | test
3 | 1 | test
4 | 2 | test2
5 | 2 | test2
How to get id of duplicates using laravel?

Answer 1

By user_id and name?
Pull user_id and name pairs

->select(['user_id', 'name'])
->groupBy(['user_id', 'name'])
->havingRaw('count(user_id) > 1')
->havingRaw('count(name) > 1')
->get()

then already on them, in a separate request, pull out the records themselves where'om.