sorry! select min(no) as no, min(name) as name, max(score) as score from table group by name order by no
select No, Name, max(score) as Score from table group by No, Name order by No
select name,max(score) from table group by name
假如是这样的 No Name Score 1 aa 88 2 aa 89 3 bb 76 4 cc 59 5 cc 78结果为 No Name Score 2 aa 89 3 bb 76 5 cc 78这样的话select min(no) as no, min(name) as name, max(score) as score from table group by name order by no 就不行了
select No, Name, max(score) as Score from table group by No, Name order by No 这样不行
select a.no, a.name, a.score from [table] as a, (select Name, max(score) as Score from [table] group by Name) as b where a.name = b.name and a.score = b.score
应是: select a.no, a.name, a.score from table as a, (select Name, max(score) as Score from table group by Name) as b where a.name = b.name and a.score = b.score
tj_dns(tj_dns) 的对 select No, Name, max(score) as Score from table group by No, Name order by No
tj_dns(tj_dns)的方法可行,也可以用下面的语句 select a.no,b.name,b.score from tablename a join (select min(name) as name,max(score) as score from tablename group by name) b on a.name=b.name and a.score=b.score
select min(no) as no, min(name) as name,
max(score) as score from table group by name order by no
from table group by No, Name order by No
No Name Score
1 aa 88
2 aa 89
3 bb 76
4 cc 59
5 cc 78结果为
No Name Score
2 aa 89
3 bb 76
5 cc 78这样的话select min(no) as no, min(name) as name,
max(score) as score from table group by name order by no
就不行了
from table group by No, Name order by No
这样不行
from [table] as a,
(select Name, max(score) as Score
from [table] group by Name) as b
where a.name = b.name and a.score = b.score
select a.no, a.name, a.score
from table as a,
(select Name, max(score) as Score
from table group by Name) as b
where a.name = b.name and a.score = b.score
select No, Name, max(score) as Score
from table group by No, Name order by No
select a.no,b.name,b.score from tablename a join (select min(name) as name,max(score) as score from tablename group by name) b
on a.name=b.name and a.score=b.score