Purpose
Returns data from the row with the oldest insertion timestamp in the specified queue table and deletes the row from the queue table.
Syntax
Required Privileges
To perform a SELECT AND CONSUME from a queue table, you must have the SELECT and DELETE privileges on that table.
Syntax Elements
- select_list
- An asterisk ( * ) or a comma-separated list of valid SQL expressions.
- queue_table_name
- Name of a queue table that was created with the QUEUE option in the CREATE TABLE statement.
ANSI Compliance
SELECT AND CONSUME is a Teradata extension to the ANSI SQL:2011 standard.