Oracle sql语句找茬

[jisuanjizhuan]

请各位看一下这条sql，错在哪儿了？ORA-00936: 缺失表达式
SELECT ROWNUM RN,* FROM (SELECT m.ID,m.MNO,m.NAME,m.NOTES,sum(s.GNUM) as GNUM
FROM MATERIAL m left join STOCK s on m.MNO=s.GCODE where 1=1
GROUP BY m.ID,m.MNO,m.NAME,m.NOTES)A;
括号里面的子查询是正确的。这条sql语句不知在sql server和mysql上是否能执行成功，没试！若能在sql server和mysql上执行成功，就这条sql而言，Oracle与mysql或sql server的区别又是什么？

[riven2011]

SELECT ROWNUM RN,*
SELECT ROWNUM RN,A.*

[Rotel-刘志东]

SELECT ROWNUM RN,a.* FROM (SELECT m.ID,m.MNO,m.NAME,m.NOTES,sum(s.GNUM) as GNUM FROM MATERIAL m left join STOCK s on m.MNO=s.GCODE where 1=1 GROUP BY m.ID,m.MNO,m.NAME,m.NOTES)A;