select * from table1 a where date=
(select max(date) from table1 where name=a.name)
and time=(select max(time) from table1 where name=a.name and date=a.date)
(select max(date) from table1 where name=a.name)
and time=(select max(time) from table1 where name=a.name and date=a.date)
group by name) A inner join tb B on A.name=B.name and [A.date]=[B.date] and A.time=B.time
(select name,max(date+time) as dt from test group by name) b
where a.name=b.name and a.date+a.time = b.dt
slect name,age,max(date),max(time),summary
from table
group by name,age,date,time,summary
你应该看看group by 的用法。
from table
group by name,summary