The difference between any and all in the database

Any is any one
All is all

Like what
SELECT * FROM student where class = ' ' and ' Age > All ' (select age from student where class = ' 02 ');
That is, the query out of 01 classes, older than 02 class all the students
Equivalent
1
SELECT * FROM student where class = ' ' and Age > (select Max (age) from student where class = ' 02 ');

and
1
SELECT * FROM student where class = ' ' and age > Any (select age from student where class = ' 02 ');
That is, the query out of 01 classes, older than 02 classes any one of the students
Equivalent
1
SELECT * FROM student where class = ' ' and Age > (select min (age) from student where class = ' 02 ');

The difference between any and all in the database