sql select count(0) from (select distinct cc.*, to_char(a1.D_DEALDATE, 'yyyy-MM-dd') D_DEALDATE, a1.C_DATA_IDF, trim(a1.C_FIELD7) ZQFL, trim(a1.C_FIEL