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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.