Lowest price ever! Learn Generative AI for 48% less!
Get my discount0
How to generate row number in SQL Without ROWNUM
2 Answers
0
Hou could add a new column of type 'Int' with the constraint auto_oncrement:
ALTER table
ADD COLUMN rno int auto_incrememt
0
Using Over partition !