查询list中执行sql ,报错:
error : ORA-00918
/* Formatted on 2015/11/25 오후 7:25:10 (QP5 v5.256.13226.35538) */
SELECT RNUM,
TOTALNO,
SUB.EV_NUM,
(SELECT M_NM_KR AS M_NM
FROM T_CD_M
WHERE L_CD = 8510)
EV_NUM,
NM,
S_DT,
E_DT,
AN_DT,
TO_CHAR (IN_DT, 'YYYY-MM-DD HH24:MI') IN_DT,
(SELECT ID
FROM T_ADMIN
WHERE A_NUM = SUB.IN_NUM)
ID,
NVL (UV, 0) UV,
NVL (PV, 0) PV
FROM (SELECT ROW_NUMBER () OVER (ORDER BY IN_DT DESC) AS RNUM,
COUNT (*) OVER () AS TOTALNO,
NM,
S_DT,
E_DT,
AN_DT,
USE_CD,
IN_DT,
IN_NUM
FROM T_EVENT , T_COM TC
WHERE USE_YN= 'Y') SUB,
( SELECT COUNT (DISTINCT (EV_NUM)) AS UV, COUNT (IN_NUM) AS PV, EV_NUM
FROM T_EVENT_VIEW
GROUP BY (EV_NUM)) TEV
WHERE SUB.EV_NUM = TEV.EV_NUM(+)
AND TE.C_NUM = TC.C_NUM
AND RNUM > TOTALNO - (TOTALNO - (10 * (1 - 1)))
AND RNUM <= TOTALNO - (TOTALNO - (10 * (1 - 1))) + 10
ORDER BY RNUM ASC;
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
error:ORA-00918 未明确定义列的错误。
例如查询的时候有2张表,都有列为A,select的时候选择A列,却没有指定是哪张表的A
RNUM重复了。是不是SUB这个子查询里查到了表T_EVENT和T_COM中相同名称的列啊