求个sql话语

求个sql语句
IDNAMESCOREDATE
1张三802011-2-10 8:03:20
2李四102011-2-10 8:01:15
3王五202011-2-10 8:02:10
4张三502011-2-10 8:10:20
5张三402011-2-10 8:00:40
6王五602011-2-10 8:04:24

查询结果

4张三502011-2-10 8:10:20
6王五602011-2-10 8:04:24
2李四102011-2-10 8:01:15

求sql，如何查出三个人最后一次的分数。结果如上图

[解决办法]

探讨

引用:

select * from Table where id in (select max(id) from Table group by Name)

这个不对吧朋友

[解决办法]
把上面的b.* 去掉就可以了
[解决办法]

探讨
SQL code

SELECT id, name, date, score
FROM Table_2 AS a
WHERE EXISTS
(SELECT id, name, date, score
FROM Tabl……

求个sql话语

热点推荐