I need to create a Unique ID in View which is not available in Table.
I searched many places but all told to use row_number. Even though i tried but its throwing an error:
Have used this SELECT Row_number() OVER(ORDER BY `locationName`) AS `RID`,
Note: `locationName` is available as column and have used in the view that have created
Can someone help out with workable code
Discussion posts and replies are publicly visible
Could you please state the error as well
I can't share complete code .. Hope this is sufficient
Can you share the error message you are receiving?