sql案例四

— 需求:sql查询每组数据中时间最大的一条

select t2.* from (select t.name, max(t.dtime) dtime from test t group by name) t1 left join test t2 on t1.name=t2.name and t1.dtime=t2.dtime;