oracle语句报错求指正

[hxnyls]

SELECT * FROM ( SELECT A.NAV_TYPE,A.KEY#ROWID_OBJECT,A.KEY#ROWID_OBJECT,ROWNUM RN
FROM (SELECT NAV_TYPE,ROWID_OBJECT as KEY#ROWID_OBJECT,ROWID_OBJECT as KEY#ROWID_OBJECT
FROM C_BO_TH_NAVIGATION WHERE 1=1) as A WHERE ROWNUM <= 1) WHERE RN >= 15

[js14982]

表别名不能用as，把as a这的as去掉

[hxnyls]

您好，还是报错 ，找了半天问题急死了

[hxnyls]

能帮我修改下么，搞半天了，无比郁闷

[js14982]

我看看，报什么错

[js14982]

a表里面为什么有两个rowid_object还重名了

[hxnyls]

SELECT * FROM ( SELECT A.* FROM (SELECT NAV_TYPE,ROWID_OBJECT as KEY#ROWID_OBJECT,ROWID_OBJECT as KEY#ROWID_OBJECT FROM C_BO_TH_NAVIGATION WHERE 1=1) A WHERE ROWNUM <= 1) WHERE RN >= 15 最开始是这样的，上面我是根据网上查的该的

[js14982]

SELECT * FROM ( SELECT A.* FROM (SELECT NAV_TYPE,ROWID_OBJECT as KEY#ROWID_OBJECT,ROWID_OBJECT as KEY#ROWID_OBJECT_1 --KEY#ROWID_OBJECT_1 这儿表别名不能一样，改一个名称 FROM C_BO_TH_NAVIGATION WHERE 1=1) A WHERE ROWNUM <= 1) WHERE RN >= 15

[学海无涯-回头是岸]

你这个语句 里面 是rownum<=1 取一条数据， 外面套一层 >=15 这个 咋取。你是不是数字写反了

[学海无涯-回头是岸]

这论坛 出bug了吗 我刚才回复的是， 里面取1 条外面取 大于15行的数据 应该是 没得结果的

[jdsnhan]

看不出来想要实现什么。 贴出测试数据及期望的结果

[卖水果的net]

SELECT * FROM (SELECT A.NAV_TYPE, A.KEY#ROWID_OBJECT, A.KEY#ROWID_OBJECT, ROWNUM RN FROM (SELECT NAV_TYPE, ROWID_OBJECT as KEY#ROWID_OBJECT, ROWID_OBJECT as KEY#ROWID_OBJECT FROM C_BO_TH_NAVIGATION WHERE 1 = 1) as A WHERE ROWNUM <= 1) WHERE RN >= 15 1、这两列的别名，重复了，你要修改其中一个才可以； 2、这里的 as 要去掉。