Retrieves any rows. Can be used with operators <, >, and = to collect specific rows.

 

Example:

Select * from employees where customer_id <= any (select customer_id from customers where customer_id = 50005800 or customer_id = 50005600)