SQLZOO, return a sequential record count for all records returned

Oracle
this should be simple - I would like to get a consecutive numbering count/id for each record returned from a query: eg: select * from tablex gives multiple rows like: field1, field2, field3, ... field1, field2, field3, ... field1, field2, field3, ... What I want is: 1, field1, field2, field3, ... 2, field1, field2, field3, ... 3, field1, field2, field3, ... 4, field1, field2, field3, ...	select rownum, field1, field2, field3 from table_name; select rownum, field1, field2, field3 from (select field1, field2, field3 from table_name order by field1, field2, field3);
Specific to Oracle
Use the psuedo-column ROWNUM. Note that ROWNUM is evaluation prior to the ORDER BY clause. To apply ROWNUM to an ordered result, use an inline view.

SQLzoo.net