How do I select all the columns from a table, plus additional columns like ROWNUM? January 9, 2023 by Tarik Qualify the * with the name of the table: select rownum, table.* from table