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
56
September 14, 2020 04:08PM
21
September 14, 2020 04:11PM


Sorry, only registered users may post in this forum.

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.