Returns data from the row with the oldest insertion timestamp in the specified queue table and deletes the row from the 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.