15.10 - Setting Up the JSON_AGG Examples - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

Create and populate table(s) to use in subsequent example(s).

CREATE TABLE emp_table (
	empID 	INTEGER,
	company	VARCHAR(50), 
	empName 	VARCHAR(20),
	empAge	INTEGER);
INSERT INTO emp_table(1, 'Teradata', 'Cameron', 24); 
INSERT INTO emp_table(2, 'Teradata', 'Justin', 34); 
INSERT INTO emp_table(3, 'Teradata', 'Someone', 24);