Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Running Window functions in mysql 5.7

malikadeelJan 3 2019 — edited Jan 4 2019

I am setting up following query in Mysql Server on my local pc and it was working fine Query is below: SELECT ID_KW,      KW,      INDEXED_DATE,      DAILY_VOLUME,      PREV_VOL,      DAILY_VOLUME - PREV_VOL DIFFERNCE  FROM (  SELECT B.ID_KW,                A.KW,                B.INDEXED_DATE,                B.DAILY_VOLUME,                LAG (DAILY_VOLUME, 1)                    OVER (PARTITION BY B.ID_KW ORDER BY B.INDEXED_DATE DESC)                    PREV_VOL            FROM KW_MASTER A, KW_VOLUME_EXACT B          WHERE A.ID_KW = B.ID_KW        ORDER BY A.KW, B.INDEXED_DATE DESC) kw When i run the same query in sqlfiddle it show me below error 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 '(PARTITION BY B.ID_KW ORDER BY B.INDEXED_DATE DESC) PREV_VOL' at line 12 Where do i need to change in above query so it will work in sqlfiddle also

This post has been answered by Gaz in Oz on Jan 4 2019
Jump to Answer

Comments

Post Details

Added on Jan 3 2019
3 comments
5,961 views