SELECT AND CONSUME Syntax | SQL Statements | Teradata Vantage - 17.05 - SELECT AND CONSUME Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)
SELECT AND CONSUME TOP 1 select_list FROM queue_table_name [;]

Syntax Elements

select_list
An asterisk ( * ) or a comma-separated list of valid SQL expressions.
If select_list specifies *, all columns from the queue table specified in the FROM clause are returned.
The select list must not contain aggregate or ordered analytical functions.
queue_table_name
Name of a queue table that was created with the QUEUE option in the CREATE TABLE statement.