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