Get list of duplicate rows in MySql
- by user347033
Hi,
i have a table like this
ID nachname vorname
1 john doe
2 john doe
3 jim doe
4 Michael Knight
I need a query that will return all the fields (select *) from the records that have the same nachname and vorname (in this case, records 1 and 2).
Can anyone help me with this? Thanks