rcs-sys/loan-parent/db/rec_loan/07-维信金科/003-check_rec_loan_yyyymmdd.sql

SELECT case when count(id) = 10 then '成功' else '失败' end as isInsert,count(1) FROM biz_prd_tran_code_mapping WHERE id in (
                                                                                                                         31,
                                                                                                                         32,
                                                                                                                         33,
                                                                                                                         34,
                                                                                                                         35,
                                                                                                                         36,
                                                                                                                         37,
                                                                                                                         38,
                                                                                                                         39,
                                                                                                                         40

    )