mysql——去重并获取最新记录

SELECT COUNT(1) FROM robot_collection_record AS b WHERE
                    NOT EXISTS (
                        SELECT
                            1
                        FROM
                            robot_collection_record
                        WHERE
                            case_id = b.case_id
                        AND b.create_time <![CDATA[ < ]]>create_time
                    )

SELECT
            COUNT(1)
        FROM
            robot_collection_record a
        WHERE
            a.create_time IN (
                SELECT
                    m.createTime
                FROM
                    (
                        SELECT DISTINCT
                            (q.case_id),
                            max(q.create_time) createTime
                        FROM
                            (
                                SELECT
                                    *
                                FROM
                                    robot_collection_record
                                WHERE
                                    partner_id = ${partnerId}
                                AND ${startTime} <![CDATA[ <= ]]> create_time
                                AND create_time <![CDATA[ <= ]]> ${endTime}
                            ) q
                        GROUP BY
                            q.case_id
                    ) m
            )
        AND a.robot_answer_state = 1;