How to display row numbers with the records?

Question

2 Answers

AdilsonLima · Answer 1 · 2024-01-19T03:35:47+0000

Display row numbers with the records numbers –

Select rownum, <fieldnames> from table;

This query will display row numbers and the field values from the given table.

rajeshsharma · Answer 2 · 2024-01-19T23:10:10+0000

In order to display row numbers along with their records numbers you can do this:

1

Select rownum <fieldnames> from table;

This above query will display the row numbers and the field values from the given table.

This query will display row numbers and the field values from the given table.