Add the row number in the query result.
Hi,
I'm trying to add the row number out of a SQL query result. It would be the equivalent of the following query in mysql:
SELECT ROW_NUMBER() AS ID, Name AS NAME, Age as AGE
FROM Table;
ID, NAME, AGE
----
1,Dan,42
2,Jo, 32
3,Jim, 35
Can this be implemented in zoho analytics?
Thanks,