每组最新的一条记录的sql语句

休假查每组最新的一条记录的sql语句
1，SELECT
aa.*,
bb.start_date AS startDate,
bb.end_date AS endDate,
bb.remark AS remark,
bb.type AS type
FROM
t_test aa
LEFT JOIN t_test_vacation bb ON (
aa.id = bb.test_id
AND bb.id IN ( SELECT max( b.id ) FROM t_test_vacation b GROUP BY b.test_id )
)
AND aa.deleted = 0

2，
SELECT
t1.id AS id,
t1.NAME AS name,
t1.sex AS sex,
t1.access AS access,
t1.birthday_date AS birthdayDate,
t1.moblie AS moblie,
t1.deleted AS deleted,
t1.age AS age,
t1.create_date AS createDate,
t1.modify_date AS modifyDate,
t1.head_path AS headPath,
(SELECT min(t2.start_date) FROM t_test_vacation AS t2 where t1.id = t2.test_id ) AS startDate,
(SELECT min(t3.end_date) FROM t_test_vacation AS t3 where t1.id = t3.test_id ) AS endDate,
(SELECT min(t4.remark) FROM t_test_vacation AS t4 where t1.id = t4.test_id ) AS remark,
(SELECT min(t5.type) FROM t_test_vacation AS t5 where t1.id = t5.test_id ) AS type
FROM
t_test AS t1