Teradata ROWNUM and ROW_NUMBER

There is no ROWNUM pseudo column available in Teradata but you may use ROW_NUMBER() aggregation function instead to get a sequence number:


SELECT 
item, 
date, 
ROW_NUMBER() OVER (ORDER BY date DESC)
FROM items