Examples: SELECT AS JSON - Advanced SQL Engine - Teradata Database

Following is the table definition for these examples.

CREATE TABLE MyTable (
a INTEGER, 
b INTEGER, 
j JSON AUTO COLUMN);

These statements insert data into the table.

INSERT INTO MyTable JSON '{"a":10,"b":1234,"extra":"1234"}';

INSERT INTO MyTable JSON '{"a":2345,"b":11,"extra":"2222"}';

This SELECT statement returns all of the columns for MyTable, ordered by the first column.

SELECT * FROM MyTable ORDER BY 1;

This statement includes the AS JSON option to return the data from columns a, b, and j in JSON format.

SELECT AS JSON a, b, j FROM MyTable;

The output is a single JSON column titled "JSON".

For SELECT AS JSON with the ORDER BY option, you must specify the column by name, not position.

SELECT AS JSON a, b FROM MyTable ORDER BY a ASC;

For SELECT AS JSON with the TOP n option, you must specify the ORDER BY column by name, not position.

SELECT AS JSON TOP 2 a, b FROM MyTable ORDER BY a DESC;