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/07/03 11:41:59

IDNameScoreTime001A902006-1-1002A802006-10-1003B952006-11-10004C502006-12-1005IDNameScoreTime001A902

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