16.20 - Examples - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

The examples in this section use the following denormalized pivoted table, star1p, which is defined as:

CREATE TABLE star1p(country VARCHAR(20),state VARCHAR(20),Q101Sales INTEGER,Q201Sales INTEGER,Q301Sales INTEGER,Q101Cogs INTEGER,Q201Cogs INTEGER,Q301Cogs INTEGER);

SELECT * FROM star1p;

country  state  Q101Sales  Q201Sales  Q301Sales  Q101Cogs  Q201Cogs  Q301Cogs
-------  -----  ---------  ---------  ---------  --------  --------  --------
Canada    ON        ?         10          ?         ?         0         ?
Canada    BC        ?          ?         10         ?         ?         0
USA       NY       45          ?          ?        25         ?         ?
USA       CA       30         50          ?        15        20         ?