Re: Partition by Clause not working

[Vignesh Kumar]

Hi Peter,

Same query

select
ROW_NUMBER() OVER w as rownum,
email,fullname,completionstate
from new_completion_view
Window w as (
partition by email, fullname
order by completionstate
);

Getting the below error

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 'w as rownum, email, fullname, completionstate from new_completion_view Window' at line 2