ID Name Score Time 001 A 90 2006-1-1 002 A 80 2006-10-1 003

天气的现象2022-10-04 11:39:541条回答

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

已提交，审核后显示！提交回复

0uqiu 共回答了18个问题 | 采纳率88.9%: 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; 1年前