16.20 - SQL Statement Structure - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Fundamentals

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

Syntax

The following diagram indicates the basic structure of an SQL statement.



statement_keyword
The name of the statement.
expressions
Literals, name references, or operations using names and literals.
functions
The name of a function and its arguments, if any.
keywords
Special values introducing clauses or phrases or representing special objects, such as NULL. Most keywords are reserved words and cannot be used in names.
clauses
Subordinate statement qualifiers.
phrases
Data attribute phrases.
;
The Teradata SQL statement separator and request terminator.
The semicolon separates statements in a multistatement request and terminates a request when it is the last nonblank character on an input line in BTEQ.
The request terminator is required for a request defined in the body of a macro.

Typical SQL Statement

A typical SQL statement consists of a statement keyword, one or more column names, a database name, a table name, and one or more optional clauses introduced by keywords. For example, in the following single-statement request, the statement keyword is SELECT:

SELECT deptno, name, salary
FROM personnel.employee
WHERE deptno IN(100, 500)
ORDER BY deptno, name ;
The select list for this statement is made up of object names:
  • Deptno, name, and salary (the column names)
  • Personnel (the database name)
  • Employee (the table name)

The search condition, or WHERE clause, is introduced by the keyword WHERE.

WHERE deptno IN(100, 500)

The sort order, or ORDER BY, clause is introduced by the keywords ORDER BY.

ORDER BY deptno, name

Related Topics

For more information about the elements that appear in an SQL statement:

For the distinction between statement and request, see “SQL Statements and SQL Requests.”