16.20 - 例: WHERE句の使用 - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ DATASETデータ型

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
2019年3月
Content Type
プログラミング リファレンス
Publication ID
B035-1198-162K-JPN
Language
日本語 (日本)

例: WHERE句の使用(AVRO)

テーブルMyavrotable09を使用する場合:

/*determine if any sale included a bicycle*/

SELECT 'TRUE'
FROM Myavrotable09
WHERE 'bicycle' = ANY(avroFile.."Item_Name");
> TRUE


/*determine if any sale was for more than $50*/ 

SELECT 'TRUE'
FROM Myavrotable09
WHERE 50 < ANY(avroFile.."Total_Price");
> TRUE

/*determine if ALL sales were for more than $50*/ 

SELECT 'TRUE'
FROM Myavrotable09
WHERE 50 < ALL(avroFile.."Total_Price");
> TRUE

例: WHERE句の使用(CSV)

テーブルMyCSVtable09を使用する場合:
/*determine if any sale included a basketball*/

SELECT 'TRUE'
FROM MyCSVtable09
WHERE 'Basketball' = ANY(csvFile.."ItemName");
> TRUE


/*determine if any sale was for more than $15*/ 

SELECT 'TRUE'
FROM MyCSVtable09
WHERE 15 < ANY(csvFile.."Total_Price");
> TRUE

/*determine if ALL sales were for more than $50*/ 

SELECT 'TRUE'
FROM MyCSVtable09
WHERE 50 < ALL(csvFile.."Total_Price");
*** No rows found