rownum is a pseudo column that assigns a row number, starting with 1 and increasing by 1, to each record returned from a select statement. row_number() SQL function and
select statements. COUNT. rownum is frequenty used to limit the number or returned records, see generate date with SQL.