分组查询最新的返回时间

方法一
走索引

SELECT
        a.id,
        a.device_id,
        b.create_time AS installationCreateTime,
        c.title
        FROM
        表a
        LEFT JOIN ota_installation b ON b.device_id = a.device_id AND b.id = (SELECT MAX(id) FROM 表b WHERE device_id = a.device_id)
        LEFT JOIN 表c ON c.id = b.campaign_id
        WHERE
        1 = 1

方法二

SELECT
	a.id,
	a.device_id,
	b.create_time AS installationCreateTime,
	c.title 
FROM
	表a
	LEFT JOIN ( SELECT device_id, MAX( create_time ) AS create_time, campaign_id FROM 表b GROUP BY device_id ) AS b ON a.device_id = b.device_id
	LEFT JOIN 表c ON c.id = b.campaign_id 
WHERE
	1 = 1