SAMPLE Clause | SQL SELECT Statements | Teradata Vantage - 17.05 - SAMPLE Clause - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

Reduces the number of rows to be considered for further processing by returning one or more samples of rows specified either as a list of fractions of the total number of rows or as a list of numbers of rows from the SELECT query.

ANSI Compliance

The SAMPLE clause is a Teradata extension to the ANSI SQL:2011 standard.