*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
This example sorts fields from the item_ext table by item_hrid, and adds a column for the row number (sequence number):
SELECT
ROW_NUMBER () OVER (ORDER BY ie.item_hrid) AS seq_no,
...