Hello,
I have a script like this:
select 1 no, name from xxx
union all
select 2 no, name from xxx
union all
select 2+rownum, name from xxx;
I want to add a query so that the row number continues from where it left off.
In other words, if the row numbers ended in the number 9, the new number should continue from 10.
I can't use with because script errors ‘invalid identifier’.
Thanks in advance for the answers.