sql server 排除名字重复数据,获取最新的数据 获取学生最高的分数信息 select * from scores a where not exists(select * from scores b where and a.score>v_b.score and a.name=b.name)