开发者社区 问答 正文

Oracle SQL 问题?报错

查询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;



展开
收起
爱吃鱼的程序员 2020-06-10 10:43:33 641 分享 版权
1 条回答
写回答
取消 提交回答
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

    error:ORA-00918 未明确定义列的错误。

    例如查询的时候有2张表,都有列为A,select的时候选择A列,却没有指定是哪张表的A

    RNUM重复了。是不是SUB这个子查询里查到了表T_EVENT和T_COM中相同名称的列啊
    2020-06-10 10:43:49
    赞同 展开评论