MySQL 8.0

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

CREATE TABLE TempTableA(F1 varchar(20), F2 varchar(20), F3 varchar(20), F4 varchar(20));
insert into TempTableA values ('A','AA','1','2019/03/01');
insert into TempTableA values ('B','BB','2','2019/03/02');
insert into TempTableA values ('B','AA','1','2019/03/03');
insert into TempTableA values ('A','BB','1','2019/03/03');
insert into TempTableA values ('B','CC','1','2019/03/05');
insert into TempTableA values ('C','CC','1','2019/03/04');
insert into TempTableA values ('C','AA','1','2019/03/02');
select *
from TempTableA
where 1=1 ;


F1
F2
F3
F4


A
AA
1
2019/03/01

B
BB
2
2019/03/02

B
AA
1
2019/03/03

A
BB
1
2019/03/03

B
CC
1
2019/03/05

C
CC
1
2019/03/04

C
AA
1
2019/03/02


select Q.* 
from (
select P.F1 as F1_1,max(P.F4) as F4_1
from TempTableA as P
where 1=1 
group by P.F1
) as R
left join TempTableA as Q on R.F1_1=Q.F1 
order by R.F4_1 desc,F4 desc


F1
F2
F3
F4


B
CC
1
2019/03/05

B
AA
1
2019/03/03

B
BB
2
2019/03/02

C
CC
1
2019/03/04

C
AA
1
2019/03/02

A
BB
1
2019/03/03

A
AA
1
2019/03/01

F1	F2	F3	F4
A	AA	1	2019/03/01
B	BB	2	2019/03/02
B	AA	1	2019/03/03
A	BB	1	2019/03/03
B	CC	1	2019/03/05
C	CC	1	2019/03/04
C	AA	1	2019/03/02