SELECT AND CONSUME SQL Statement | VantageCloud Lake - SELECT AND CONSUME - Teradata Vantage

Returns data from the row with the oldest insertion timestamp in the specified queue table and deletes the row from the queue table.

• SELECT AND CONSUME Syntax
• SELECT AND CONSUME Usage Notes
• Example: Returning the Row Having the Oldest QITS Value in a Queue Table

ANSI Compliance

SELECT AND CONSUME is a Teradata extension to the ANSI SQL:2011 standard.

Required Privileges

To perform a SELECT AND CONSUME from a queue table, you must have the SELECT and DELETE privileges on that table.