mysql group by 或in

         select  older_id     
  from healthy

             select  older_id 
  from healthy where older_id in (1,2,3)

select older_id
  from healthy
  group by older_id

select  older_id 
  from healthy where older_id in (1,2,3) GROUP BY older_id

select  id,older_id, create_time
  from healthy
  group by older_id     报错，id,和create_time没有排序的规则，会不知道选哪一个

 select  older_id,max(create_time)
  from healthy
  group by older_id

 select  older_id,weight,max(create_time)
  from healthy
  group by older_id 报错 ，weight不知道怎么排序

select older_id,weight,heart,blood,sugar
from healthy h 
where older_id in (
  select older_id            
  from healthy
) and create_time in (SELECT max(create_time) FROM healthy)     

是id在（1，1，2，2，3）中 并且时间是所有当中最大的

select older_id,weight,heart,blood,sugar,create_time
from healthy h 
where  create_time in (
  select  max(create_time)
  from healthy
  group by older_id
) ;

时间根据排序选出了三个，但有一个时间有重复的所以查4个

select older_id,weight,heart,blood,sugar,create_time
from healthy h 
where  (older_id,create_time) in (
  select older_id, max(create_time)
  from healthy
  group by older_id
) ;

到底怎么回事我不清除，我就想像成一组，类似Map集合。older_id和create_time相互对应，限制成为三个  ，猜的  ,需求满足不过排序不是我想要的

select older_id,weight,heart,blood,sugar,create_time
from healthy h 
where  (older_id,create_time) in (
  select older_id, max(create_time)
  from healthy
  group by older_id
)  group by older_id;     报错

select older_id,weight,heart,blood,sugar,create_time
from healthy h 
where  (older_id,create_time) in (
  select older_id, max(create_time)
  from healthy
  group by older_id
)  group by older_id ， create_time;  更错  

select older_id,weight,heart,blood,sugar,create_time
from healthy h 
where  (older_id,create_time) in (
  select older_id, max(create_time)
  from healthy
  group by older_id
)  group by id;     能查出，不过顺序没变化，本来就是按id排序

未知该怎么玩