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
246
September 14, 2020 04:08PM
115
September 14, 2020 04:11PM
73
October 08, 2020 11:36AM
66
October 09, 2020 09:11AM
57
October 09, 2020 11:59AM
83
October 08, 2020 09:25AM


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.