Get list of duplicate rows in MySql

Posted by user347033 on Stack Overflow See other posts from Stack Overflow or by user347033
Published on 2010-05-21T11:54:46Z Indexed on 2010/05/21 12:00 UTC
Read the original article Hit count: 312

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about mysql

Related posts about sql