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’，我看了字段啥的都没问题啊
求
