Correlated Subquery Examples | SQL SELECT Statements | Teradata Vantage - 17.05 - Example: Combining Equality and Inequality Conditions in a Correlated Subquery - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

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);