SQLCODE=-206, SQLSTATE=42703

Question

SELECT
    *
FROM
    (   SELECT
            REC_CREATOR                                        AS "recCreator",
            REC_CREATOR_NAME                                   AS "recCreatorName",
            REC_CREATE_TIME                                    AS "recCreateTime",
            REC_REVISOR                                        AS "recRevisor",
            REC_REVISOR_NAME                                   AS "recRevisorName",
            REC_REVISE_TIME                                    AS "recReviseTime",
            ARCHIVE_FLAG                                       AS "archiveFlag",
            ARCHIVE_TIME                                       AS "archiveTime",
            ARCHIVE_STAMP_NO                                   AS "archiveStampNo",
            SEQ_NUM                                            AS "seqNum",
            COMPANY_CODE                                       AS "companyCode",
            SALE_ORG                                           AS "saleOrg",
            CURRENCY                                           AS "currency",
            DELIVERY_DATE_6                                    AS "deliveryDate6",
            RATE                                               AS "rate",
            VERSION_NUM                                        AS "versionNum",
            DISC_DAYS                                          AS "discDays",
            DISC_BASE_DATE                                     AS "discBaseDate",
            DISC_MODE                                          AS "discMode",
            REMARK                                             AS "remark",
            REMARK1                                            AS "remark1",
            REMARK2                                            AS "remark2",
            REMARK3                                            AS "remark3",
            NOTE_TYPE                                          AS "noteType",
            PAPER_TYPE                                         AS "paperType",
            RATE_START_DATE                                    AS "rateStartDate" ,
            DECODE(RATE_END_DATE,' ','99991231',RATE_END_DATE) AS "rateEndDate"
        FROM
            ISMS.TSAHYSA16 
        WHERE 
            NOTE_TYPE = 'B61'
        AND PAPER_TYPE ='1' ) A16
        WHERE 1=1
        AND A16.RATE_START_DATE<= '20220201'
        AND A16.rateEndDate >='99991231'

这个报sqlcode=‘-206’，我看了字段啥的都没问题啊
求

Answer 1

删除select前面的(`)符号再试试：