SQLite Forum

How to filter find duplicate and show row with same field using sqlite code?
Login
Hello, I am learning the SQL code and don't know how to find the duplicate row and show it out.
Here is the table

person_no name birthday
01 John 01/01/2000
02 John 15/03/2000
03 Marry 21/06/2000
04 Peter 23/12/2000
05 Jerry 12/07/2000

The person_no is unique for everyone, but the name may be same, anyway to find the people with the same name but different person_no ?

Sorry if my question bothers you