MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE stuff(
   id   INTEGER  NOT NULL
  ,name VARCHAR(60) NOT NULL
  ,city VARCHAR(60) NOT NULL
);
INSERT INTO stuff(id,name,city) VALUES 
  (904834,'jim','London')
, (904835,'jim','London')
, (90145,'Fred','Paris')
, (90132,'Fred','Paris')
, (90133,'Fred','Paris')

, (923457,'Barney','New York')
;


Records: 6  Duplicates: 0  Warnings: 0


SELECT
    t.*
FROM (
    SELECT
        s.*
      , COUNT(*) OVER (PARTITION BY s.name, s.city) AS qty
    FROM stuff s
    ) t
WHERE t.qty > 1
ORDER BY t.name, t.city


id
name
city
qty


90145
Fred
Paris
3

90132
Fred
Paris
3

90133
Fred
Paris
3

904834
jim
London
2

904835
jim
London
2

id	name	city	qty
90145	Fred	Paris	3
90132	Fred	Paris	3
90133	Fred	Paris	3
904834	jim	London	2
904835	jim	London	2