求个sql话语
求个sql语句IDNAMESCOREDATE1张三802011-2-10 8:03:202李四102011-2-10 8:01:153王五202011-2-10 8:02:104
求个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，如何查出三个人最后一次的分数。结果如上图
[解决办法]
[解决办法] 把 上面的b.* 去掉就可以了
[解决办法]
