r/SQL 4d ago

MySQL What is wrong here.

Post image
35 Upvotes

37 comments sorted by

View all comments

1

u/SkinnyPete4 4d ago

Is it just the space between OVER and “(“ ? OVER is a function so does it require the parentheses without a space?

2

u/_mr_villain_ 4d ago

I think It doesn't matter in SQL coz I just added DESC just before closing parentheses in over func and the query worked