分组查询最近时间的记录

select * from ss_test_result as b where not exists(select 1 from ss_test_result where service_id= b.service_id and b.create_date<create_date )