sql第二题语句怎么写

Question

sql语句是什么,那个时间怎么弄？？？？？

Answer 1

select * from department d

left join (select  id,Max(createTime)  as createTime from department group by id) t on t.id = d.id

where d.createTime = t.createTime