How to generate row number in SQL Without ROWNUM

Answer 1

Hou could add a new column of type 'Int' with the constraint auto_oncrement:

ALTER table
ADD COLUMN rno int auto_incrememt

Answer 2

Using Over partition !