This CREATE TABLE statement creates a queue table named shopping_cart:
CREATE SET TABLE shopping_cart, QUEUE ( cart_qits TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), product_id INTEGER, quantity INTEGER ) PRIMARY INDEX (product_id);
This SELECT AND CONSUME statement returns all the columns of the row with the oldest value in the cart_qits column of the shopping_cart table:
SELECT AND CONSUME TOP 1 * FROM shopping_cart;