MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable(
   ID     INTEGER  NOT NULL 
  ,B      VARCHAR(3) NOT NULL
  ,C      VARCHAR(4) NOT NULL
  ,date01 DATE  NOT NULL
  ,date02 DATE  NOT NULL
  ,date03 DATE  NOT NULL
);
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (11,'xxx','xxxx','2020-05-01','2020-05-02','2020-06-02');
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (11,'xxx','xxxx','2020-06-01','2020-06-03','2020-05-02');
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (11,'xxx','xxxx','2020-07-01','2020-07-03','2020-06-30');
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (11,'xxx','xxxx','2020-07-01','2020-06-03','2020-06-30');
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (11,'xxx','xxxx','2020-01-01','2020-01-08','2020-05-02');
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (11,'xxx','xxxx','2020-02-01','2020-01-31','2020-05-02');
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (22,'xxx','xxxx','2020-05-01','2020-05-02','2020-06-02');
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (22,'xxx','xxxx','2020-06-01','2020-06-03','2020-05-02');
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (22,'xxx','xxxx','2020-07-01','2020-07-03','2020-06-30');
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (22,'xxx','xxxx','2020-07-01','2020-06-03','2020-06-30');
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (22,'xxx','xxxx','2020-01-01','2020-01-08','2020-05-02');
INSERT INTO mytable(ID,B,C,date01,date02,date03) VALUES (22,'xxx','xxxx','2020-02-01','2020-01-31','2020-05-02');
select t.*
from mytable t
where (t.date01, t.date02, t.date03) = (
    select t1.date01, t1.date02, t1.date03 
    from mytable t1 where t1.id = t.id
    order by t1.date01 desc, t1.date02 desc, t1.date03 desc
    limit 1
)


ID
B
C
date01
date02
date03


11
xxx
xxxx
2020-07-01
2020-07-03
2020-06-30

22
xxx
xxxx
2020-07-01
2020-07-03
2020-06-30


select *
from (
	select 
		t.*, 
		row_number() over(partition by id order by date01 desc, date02 desc, date03 desc) rn
	from mytable t
) t
where rn = 1


ID
B
C
date01
date02
date03
rn


11
xxx
xxxx
2020-07-01
2020-07-03
2020-06-30
1

22
xxx
xxxx
2020-07-01
2020-07-03
2020-06-30
1
ID	B	C	date01	date02	date03
11	xxx	xxxx	2020-07-01	2020-07-03	2020-06-30
22	xxx	xxxx	2020-07-01	2020-07-03	2020-06-30