Subquery in WITH CHECK OPTION

Subquery in WITH CHECK OPTION is a SQL statement in the Subqueries category. Using ALL, SOME, or ANY with comparison operators for multi-value subquery comparisons. The syntax is SELECT * FROM table WHERE condition = ALL/SOME/ANY (subquery);. It returns multi-value comparison. A typical example: -- ALL: greater than ALL values in subquery SELECT name, salary FROM employees WHERE salary > ALL ( SELECT salary FROM employees WHERE department = 'IT' ); -- Salary higher than EVERY person in IT -- ANY/SOME: greater than at least one SELECT name, salary FROM employees WHERE salary > ANY ( SELECT salary FROM employees WHERE department = 'IT' ); -- Salary higher than at least one person in… A close relative is Scalar Subquery, which a subquery that returns a single value (one row, one column). Can be used in SELECT, WHERE, HAVING clauses. A close relative is Correlated Subquery, which a subquery that references columns from the outer query. Evaluated for each row of the outer query.