15.10 - SELECT - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.