Qracle SQL using Partition By throws a keyword expected error

I know you've only posted one line of code, but you can make it stand out by formatting it as code. See Wiki - how to post code on this forum. Thanks.