How to add numbered results to select?

Question

SQL

I have a table with no id column.

How can I add an id column without using DDL statements. I need to do this in a select call

. I know that window functions can be used. For example:
ROW_NUMBER() OVER (ORDER BY name) AS id

But here it is necessary to specify sorting, I just want the id column to be added, which would go in order from the table that I already have.

Answer 1

I just want to add an id column that would go in order from the table that I already have.

Break off.
There is no order in the table, the table is an unsorted heap. The order in which the records were inserted into the table is nothing more than temporary visibility. And the order that is issued now, easily has every right to change tomorrow. And it will definitely change - moreover, according to the law of great meanness at the most inconvenient moment for you.
Sorting is not a show off, but a conscious necessity. The only way to get a deterministic result.