Example: Combining Equality and Inequality Conditions in a Correlated Subquery - Teradata Vantage

You can use correlated subqueries to specify a combination of equality and inequality constraints with the subquery.

For example, to select the names of all students who are younger than all students at the same grade, you can perform the following query:

SELECT name
FROM student st1
WHERE age < ALL (SELECT age
                 FROM student st2
                 WHERE st1.grade = st2.grade
                 AND st1.stno <> st2.stno);