Oracle Some, any, all three of the differences and personal summary, induction!

Any: if it is greater than (a > B), then all values in a that are greater than the smallest number in B will be output.

If the number is less than (a < b), then all values in a that are smaller than the largest of B will be output.

SELECT * from T_hq_ryxx where Gongz > A (select Pingjgz from T_HQ_BM);

Some: usage is the same as any, except that any is used in a non-environment.

All: If it is greater than (a > B), then all values in a that are greater than the largest number in B will be output.

If it is less than (a < b), then all values in a that are smaller than the smallest number in B will be output.

SELECT * from T_hq_ryxx where Gongz > All (select Pingjgz from T_HQ_BM);

Any is greater than the smallest, less than the maximum.

All is greater than the maximum, less than the smallest.

Oracle Some, any, all three of the differences and personal summary, induction!