Resolved: ROW_NUMBER() is not working
When I'm trying to use ROW_NUMBER() it seems that MySql is not reading it properly (the line is black not blue) hence is not working. It has to do with the MySQL version? And how can I fix that?
The error received is: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '() AS row_num FROM salaries' at line 2
The current version seems to be 5.7 as in the image:
I'm eagerly awaiting your response,
As I said above, the problem was with the MySQL version, after I installed the latest version, it works!
Thanks for reaching out and letting us about the solution of your issue, as well as letting us know that you can proceed with the course.
Good luck and please feel free to post another question should you encounter any difficulties. Thank you.