MySQL 5.5

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

create table data
(id varchar(30),tname varchar(30),
tlast int ,tdata int);
insert into data values (100,'Alex', 50,234);
insert into data values (101,'Blue', 10,233),(101,'Blue', 10,324),(102,'Blue', 20,544),(102,'Blue', 20,384);
insert into data values  (103,'Eva', 201,384), (104,'Eva', 301,384), (105,'Eva', 401,382), (105,'Eva', 401,284);
insert into data values (106,'rex0220', 100,394), (107,'rex0220', 200,294), (107,'rex0220', 200,384);

Records: 4  Duplicates: 0  Warnings: 0



Records: 4  Duplicates: 0  Warnings: 0



Records: 3  Duplicates: 0  Warnings: 0


select * from data
order by tname,tlast


id
tname
tlast
tdata


100
Alex
50
234

101
Blue
10
233

101
Blue
10
324

102
Blue
20
544

102
Blue
20
384

103
Eva
201
384

104
Eva
301
384

105
Eva
401
382

105
Eva
401
284

106
rex0220
100
394

107
rex0220
200
294

107
rex0220
200
384


create table data2
(id varchar(30),tname varchar(30),
tlast int ,tdata int);
insert into data2 values (100,'Alex', 50,234);
insert into data2 values (102,'Blue', 20,544),(102,'Blue', 20,384);
insert into data2 values (105,'Eva', 401,382), (105,'Eva', 401,284);
insert into data2 values (107,'rex0220', 200,294), (107,'rex0220', 200,384);

Records: 2  Duplicates: 0  Warnings: 0



Records: 2  Duplicates: 0  Warnings: 0



Records: 2  Duplicates: 0  Warnings: 0


select * from data2
order by tname,tlast


id
tname
tlast
tdata


100
Alex
50
234

102
Blue
20
544

102
Blue
20
384

105
Eva
401
382

105
Eva
401
284

107
rex0220
200
294

107
rex0220
200
384


select *
  from data 
 where id in (
         select id
           from data
          where (tname, tlast) in (
                select tname, max(tlast) as tlast
                  from data
                 group by tname));


id
tname
tlast
tdata


100
Alex
50
234

102
Blue
20
544

102
Blue
20
384

105
Eva
401
382

105
Eva
401
284

107
rex0220
200
294

107
rex0220
200
384

id	tname	tlast	tdata
100	Alex	50	234
101	Blue	10	233
101	Blue	10	324
102	Blue	20	544
102	Blue	20	384
103	Eva	201	384
104	Eva	301	384
105	Eva	401	382
105	Eva	401	284
106	rex0220	100	394
107	rex0220	200	294
107	rex0220	200	384