oracle 语句问题
select * from (select Row_Number() over (Order by agentcode) as RowId, * from commission ) U where U.RowId between 1 and 4 报错:ora-00923:未找到要求的from关键字 不明白啊,求指教
select * from (select Row_Number() over (Order by agentcode) as RowId, * from commission ) U where U.RowId between 1 and 4 报错:ora-00923:未找到要求的from关键字 不明白啊,求指教
答案:改成这样
select * from (select Row_Number() over (Order by agentcode) as rn, a.* from commission a ) U where U.rn between 1 and 4
rowid是关键字
其他:from后面应该是表吧
上一个:Oracle数据库函数有几种与作用
下一个:想学点数据库,买了一本书讲oracle 10g的,但是在网上下软件的时候,每个版本下面都有四个文件