SQL Server 2019 (Linux)

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')
;

6 rows affected

SELECT *
FROM stuff s
WHERE EXISTS (
   SELECT 1
   FROM stuff ss
   WHERE 
	  s.name = ss.name
   AND
	  s.city = ss.city
   HAVING COUNT(*) > 1
)


id
name
city


904834
jim
London

904835
jim
London

90145
Fred
Paris

90132
Fred
Paris

90133
Fred
Paris

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