SQLite Forum: How to filter find duplicate and show row with same field using sqlite code?

You can use a window function too. Maybe somebody finds an even better solution
for window functions.

SELECT person_no, name, birthday
FROM (
  SELECT 
    person_no,
    name,
    birthday,
    count(name) OVER (
      PARTITION BY name
    ) counter
  FROM
    person
)
WHERE counter > 1

or 

WITH counted_persons AS (
  SELECT 
    *,
    count(name) OVER (
	    PARTITION BY name
    ) counter
  FROM
    person)
SELECT person_no, name, birthday FROM counted_persons WHERE counter > 1