Set Operators in Subqueries Example 4

Set Operators in Subqueries Example 4 - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

Language

English (United States)

Last Update

2024-04-03

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

SELECT * 
FROM table_1 
WHERE x1 IN 
(SELECT MAX(x2) 
FROM table_2 
UNION 
SELECT MIN(x3) 
FROM table_3);