sql语句分组查询最新的一次记录

  SELECT   *

        from (
								select info.*  from  xxl_job_info  info inner join
								(
														SELECT
														t1.*
														FROM
														xxl_job_log AS t1
																INNER JOIN (
																				SELECT
																				job_id,
																				MAX(trigger_time) AS max_create_time
																				FROM
																				xxl_job_log
																				GROUP BY
																				job_id
																) AS t2 ON t1.job_id = t2.job_id
														AND t1.trigger_time = t2.max_create_time
														)
								
								
								

								log on   info.trigger_status = 1 and  info.author ="renwu"
								

								and


								info.job_group =3 and info.id = log.job_id    and
								log.trigger_code in (0, 200) and log.handle_code = 0


        ) t

		SELECT
														t1.*
														FROM
														xxl_job_log AS t1
																INNER JOIN (
																				SELECT
																				job_id,
																				MAX(trigger_time) AS max_create_time
																				FROM
																				xxl_job_log
																				GROUP BY
																				job_id
																) AS t2 ON t1.job_id = t2.job_id
														AND t1.trigger_time = t2.max_create_time
														)