Oracle Sql 语句里的分析函数问题

Question

错误信息：
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select count(*) SELECT t.name,u.userid,u.duties,u.sex,u.email,u.inemail,u.name uname,u.telephone,u.mobile_phone,u.fax,u.vmphone, row_number() OVER (PARTITION BY t.opriority ]; nested exception is java.sql.SQLException: ORA-00923: 未找到要求的 FROM 关键字
后台代码：
queryQL.append("SELECT t.name,u.userid,u.duties,u.sex,u.email,u.inemail,u.name uname,u.telephone,u.mobile_phone,u.fax,u.vmphone, ");
queryQL.append("row_number() OVER (PARTITION BY t.opriority ORDER BY gu.priority) upriority ");
queryQL.append("FROM ( ");
queryQL.append("SELECT o.nodeid,o.code,o.name,o.groupid,ROWNUM opriority ");
queryQL.append("FROM uap_organ_node o ");
queryQL.append("WHERE o.removed='0' ");
queryQL.append("START WITH o.nodeid=10000 ");
queryQL.append("CONNECT BY o.parentnodeid=PRIOR o.nodeid ");
queryQL.append("ORDER SIBLINGS by o.priority ");
queryQL.append(") t,uap_group_user gu,uap_user u ");
queryQL.append("WHERE t.groupid=gu.groupid AND gu.userid=u.userid ");
queryQL.append("AND u.userid<>1 ");

Answer 1

sql语句拼写有误，建议使用sqldeveloper，可以检查你sql的语法