JSON_AGG Function Examples | Teradata Vantage - Setting Up the JSON_AGG Examples - Advanced SQL Engine - Teradata Database

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);