Examples

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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         ?