Is it possible to add automatic row numbering to a table generated by the Table Transform Macro. Embedding the Table Transform Macro into Table Plus does not seem to work.
SELECT *, ROWNUM() AS '_' FROM T*
Here you can find the list of SQL functions and the ROWNUM() function.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @David Wu,
Note that there's also a row numbering option using the Table Filter macro.
Katerina
Stiltsoft
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.