ID Name Score Time 001 A 90 2006-1-1 002 A 80 2006-10-1 003 B 95 2006-11-10 004 C 50 2006-12-1 005

来源：学生作业帮助网编辑：作业帮时间：2024/04/28 05:13:15

ID Name Score Time 001 A 90 2006-1-1 002 A 80 2006-10-1 003 B 95 2006-11-10 004 C 50 2006-12-1 005
ID Name Score Time 001 A 90 2006-1-1 002 A 80 2006-10-1 003 B 95 2006-11-10 004 C 50 2006-12-1 005

ID Name Score Time 001 A 90 2006-1-1 002 A 80 2006-10-1 003 B 95 2006-11-10 004 C 50 2006-12-1 005
select * from 表名 where exists
(select 表名 as a,
(select name,max(time) as time from 表名 group by name) as b
where a.name=b.name and a.time=b.time)
vaela