[SQL] SELECT R.* FROM ( SELECT (ROW_NUMBER () OVER (ORDER BY a.id3 ASC)) AS rownum, id,id2,id3
fromxxxawherea.id2='xxxxxxx')RWHERER.rownumBETWEEN1AND15[Err]ORA-00923:未找到要求的FROM关键字...
from xxx a
where a.id2 = 'xxxxxxx'
)R
WHERE R.rownum BETWEEN 1 AND 15
[Err] ORA-00923: 未找到要求的 FROM 关键字 展开
where a.id2 = 'xxxxxxx'
)R
WHERE R.rownum BETWEEN 1 AND 15
[Err] ORA-00923: 未找到要求的 FROM 关键字 展开
展开全部
select r.*
from
(SELECT (ROW_NUMBER () OVER (ORDER BY a.id3 ASC) as rn,id,id2,id3 from xxx a where a.id2 = 'xxxxxxx') r
WHERE R.rnBETWEEN 1 AND 15
你别起别名叫rownum，这是oracle关键字 ，另外你子查询写法不对
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
