SELECT inner.*
FROM (SELECT ROWNUM AS num, inner0.*
FROM (SELECT *
FROM TBLCOMMUNICATION A,TBLCOMMUNICATETYPE B,TBLCATALOG C
WHERE A.TYPEID = B.TYPEID (+) AND A.CATALOGID=C.CATALOGID(+)
order by a.Communicationid desc ) inner0
WHERE ROWNUM<11) inner
WHERE inner.num>=1错误提示:未明确定义列
FROM (SELECT ROWNUM AS num, inner0.*
FROM (SELECT *
FROM TBLCOMMUNICATION A,TBLCOMMUNICATETYPE B,TBLCATALOG C
WHERE A.TYPEID = B.TYPEID (+) AND A.CATALOGID=C.CATALOGID(+)
order by a.Communicationid desc ) inner0
WHERE ROWNUM<11) inner
WHERE inner.num>=1错误提示:未明确定义列
解决方案 »
- 如何构筑动态模糊查询语句
- 数据库建表出错
- 这样的查询如何实现?
- 优化sql语句
- 问题:很菜的问题 TYPE type_name IS TABLE OF {columble.column%TYPE} [NOT NULL] [INDEX BY BINARY_INTEGER];identifier
- case when 可不可以判斷某字段是否為空。如:case when bookqty1 is null then bookqty1 else bookqty2
- 如何实现当库存量为0的时候,不能在在出货表中插入新数据?---急!
- 请问一条SQL语句
- oracle某张表中索引混乱!
- oracle imp两张大表千万条数据直接卡死
- 请教关于Oracle统计问题
- SQL别名怎么写?
FROM (SELECT ROWNUM AS num, inner0.*
FROM (SELECT *
FROM TBLCOMMUNICATION A left outer join TBLCOMMUNICATETYPE B on A.TYPEID = B.TYPEID left outer join TBLCATALOG C on A.CATALOGID=C.CATALOGID
) inner0
WHERE ROWNUM<11) inner
WHERE inner.num>=1
好象这样可以,我的是10G
好好改改名字,sql应该没有问题。