I am trying to help someone who wants to put data into alphabetical order with a row number. I thought I could do a query like this
select "name", ROWNUM() as "Row" from "data" order by "name"
But I just get a 'permission denied' error or similar.
Can anyone help? Does ROWNUM() work the way I think it should? Or is there a better way to get a row number on the data ordered by name?
Here is the error I am getting:
Access is denied: ROWNUM in statement [SELECT "Description", ROWNUM( ) FROM "Data" ORDER BY "Description" ASC]