Example: SELECT with Queue Tables - Teradata VantageCloud Lake

The following statement measures the queue depth of a queue table named shopping_cart:

     SELECT COUNT(*)
     FROM shopping_cart;

Assuming the column named cart_qits contains QITS values, this statement returns the shopping_cart queue table in FIFO order:

     SELECT *
     FROM shopping_cart
     ORDER BY cart_qits;