30485 oracle,求教ORA-30485: 在窗口说明中丢失 ORDER BY 表达式问题解决办法

在网上找了很多关于在窗口说明中丢失 ORDER BY 表达式问题解决办法的问题解决方法，都没有找到具体解决办法，求助各位大神。

SELECT n.id, n.NAME,n.fileType,n.path,u.nameCh AS

"author",n.uploadDate,s.skillName,n.readTimes,n.downTimes,n.iconcss,

(SELECT count(fid) FROM his_knowledge WHERE fid = n.id) AS "hisCounts",

(SELECT count(fid) from message where fid = n.id ) as "leaveMsg",vf.verifydate

FROM

KnowLedge n,skillInfo s,userInfo u,

(SELECT *

FROM (SELECT ROW_NUMBER()  OVER(PARTITION BY FID order by   VERIFYDATE DESC) rn,

verifyinfo.*

FROM verifyInfo)

WHERE rn = 1) vf

WHERE s.skillId = n.skillId

and n.id= vf.fid

AND

u.userId = n.author

AND n. STATUS = 0

AND n.verify = 1

AND n.isleaf = 1

这个sql在PL/SQL中可以正常运行，但是放在ibatis中报错;