例 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ操作言語

Product: Advanced SQL Engine; Teradata Database
Release Number: 17.10
Published: 2021年7月
Language: 日本語
Last Update: 2021-09-23
dita:mapPath: ja-JP/vjt1596846980081.ditamap
dita:ditavalPath: ja-JP/wrg1590696035526.ditaval
dita:id: B035-1146
Product Category: Software; Teradata Vantage

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