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

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.