MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.27


create table test123(a int, b int,c int);
insert into test123 values (rand()*1000,rand()*1000,rand()*1000);
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;
insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;
insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;
insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;
insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;
insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;
insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;
insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;
insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;
insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;
insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;
insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;


a
b
min(t2.c)


2
null
null


insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;


a
b
min(t2.c)


2
2
224


insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;


a
b
min(t2.c)


2
2
128


insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;


a
b
min(t2.c)


2
2
128


insert into test123 select rand()*1000,rand()*1000,rand()*1000 from test123;
select t1.a, t2.b, min(t2.c) from test123 t1 left join test123 t2 on t2.b=t1.a group by t1.a having t1.a=2;


a
b
min(t2.c)


2
2
24


select * from test123 where a=2 and b=2