Retrieves all rows. ALL is the default for a SELECT statement. Can be used with operators <, >, = to collect specific rows.

 

Example:

Select * from employees where customer_id >= all (select customer_id from customers where customer_id = 50005800 or customer_id = 50005600)