MySQL 5.5

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

create table data
(tname varchar(20),
tlast int);
insert into data values ('rex0220', 100), ('rex0220', 200);
insert into data values  ('Eva', 201), ('Eva', 301), ('Eva', 401);
insert into data values  ('John', 202),('John', 302),('John', 402),('John', 502);
select * from data


tname
tlast


rex0220
100

rex0220
200

Eva
201

Eva
301

Eva
401

John
202

John
302

John
402

John
502


SELECT tname, MIN(tlast)
FROM data
GROUP BY tname
HAVING (COUNT(tname) > 1)


tname
MIN(tlast)


Eva
201

John
202

rex0220
100

tname	tlast
rex0220	100
rex0220	200
Eva	201
Eva	301
Eva	401
John	202
John	302
John	402
John	502