例: ARRAY_AGGを使用して給与を集計 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - JSONデータ型

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
Language
日本語
Last Update
2021-09-23
dita:mapPath
ja-JP/uwa1591040057999.ditamap
dita:ditavalPath
ja-JP/wrg1590696035526.ditaval
dita:id
evi1472243742653
Product Category
Software
Teradata Vantage
ARRAY_AGGを使用して、職種の給与を集約します。
例では、以前に作成したテーブルを使用します。
SELECT salary, ARRAY_AGG(pos ORDER BY empId, NEW varchararr5()) 
FROM employeeTable 
GROUP BY salary
ORDER BY salary;
結果:
salary 	 ARRAY_AGG(pos ORDER BY empId ASC, NEW varchararr5())
-------------------------------------------------------------
50000 ('engineer','engineer','salesman','salesman','manager')
75000 ('engineer','salesman','manager')
100000  ('engineer','salesman','manager')
125000  ('manager','executive')
150000  ('executive','executive')
200000  ('executive')
1000000 ('executive')