16.20 - SELECT - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The expression to be associated with the column_name list is to select from one or more existing user base tables or views.

DISTINCT
Only one row is to be returned from any set of duplicates that might result from a given expression list.
Two rows are considered duplicates only if each value in one is equal to each corresponding value in the other.
You cannot specify a DISTINCT operator if the view definition also includes a TOP n or TOP m PERCENT specification.
ALL
All rows, including duplicates, are to be returned in the results of the expression list.
This is the default value.