MySQL Forums
Forum List  »  MySQL Workbench

OVER (PARTITION BY) : Not Working
Posted by: James Su
Date: September 14, 2020 04:08PM

Good Afternoon -

Hoping you lot can help me out here.
I have prior experience using the following function in SQL Server Mgmt Studio -

'COUNT(xxx.yyy) OVER (PARTITION BY xxx.zzz) AS '1234'

From all of the MySQL documentation I have read, the above format should be acceptable for this function to work properly, however, no matter what I try I receive "error code 1064: Error in your SQL Syntax: check the manual that corresponds to your version"

I am currently using 8.0.21, which is the latest version.

Please let me know if you have any insight, very appreciated!
Thank you!

Options: ReplyQuote


Subject
Views
Written By
Posted
OVER (PARTITION BY) : Not Working
1020
September 14, 2020 04:08PM
380
September 14, 2020 04:11PM
332
September 14, 2020 04:49PM
211
October 08, 2020 11:36AM
211
October 09, 2020 09:11AM
196
October 09, 2020 11:59AM
317
October 08, 2020 09:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.