按时间倒序取分组第一条

 SELECT * FROM(SELECT
        sor.vehicle_number as vehicleNumber,
        js.js_id AS jsId,
        u.real_name AS jsName,
        u.photo AS img,
        js.js_station AS jsStation,
        sor.id AS taskId,
        sor.fault_description AS faultDescription,
        sor.create_time AS createTime,
        ot.create_time AS lcCreateTime,
        js.js_company AS jsCompany,
        t1.name AS faultType,
        ot.lc_id AS lcId,
        ot.task_name AS taskName,
        ot.now_cl_ids AS clr,
        ot.task_status AS taskNowStatus,
        ROW_NUMBER() OVER ( PARTITION BY sor.id ORDER BY ot.create_time DESC ) AS row_num
        FROM
        b_support_online_record sor
        LEFT JOIN online_support_js js ON sor.id = js.task_id
        LEFT JOIN online_task ot ON sor.id = ot.task_id
        LEFT JOIN online_support_jszj jszj ON sor.id = jszj.task_id
        LEFT JOIN online_support_zcdlgcs zcdlgcs ON sor.id = zcdlgcs.task_id
        LEFT JOIN sys_user u on u.id = js.js_id
        Left JOIN sys_dict_data_value t1 ON sor.fault_type = t1.code
        LEFT JOIN sys_dict_data t2 on t1.dict_id = t2.id
        WHERE 1=1
        AND sor.id IN (
        SELECT DISTINCT task_id
        FROM online_support_js
        WHERE js_company = (
        SELECT DISTINCT js_company
        FROM online_support_js
        WHERE 1=1
        AND qygcs_ids LIKE CONCAT("%", #{userId}, "%")))
        AND t2.code = 'faultType'
        ) AS t WHERE t.row_num =1