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.