SQL

sql all

Returns true if all of the subquery values meet the passed condition.
Example: Returns the users with a higher number of tasks than the user
with the highest number of tasks in the HR department (id 2)
SELECT first_name, surname, tasks_no
FROM users
WHERE tasks_no > ALL (SELECT tasks FROM user WHERE
department_id = 2);

SQL ALL

SELECT * 
FROM Teachers
WHERE age >  ALL (
  SELECT age
  FROM Students
);

SQL SELECT ALL

SELECT *
FROM Customers;

sql all

Returns true if all of the subquery values meet the passed condition.
Example: Returns the users with a higher number of tasks than the user
with the highest number of tasks in the HR department (id 2)
SELECT first_name, surname, tasks_no
FROM users
WHERE tasks_no > ALL (SELECT tasks FROM user WHERE
department_id = 2);

SQL ALL

SELECT * 
FROM Teachers
WHERE age >  ALL (
  SELECT age
  FROM Students
);

SQL SELECT ALL

SELECT *
FROM Customers;