SELECT 班级, 姓名,MAX(分数) AS 最高分数 FROM TableX GROUP BY 班级, 姓名
select 班级,姓名,max(分数) as fs,备注 from tablename group by 姓名
select a.班级, a.姓名,a.分数 AS 最高分数 from tablename a join ( select 班级, max(分数) as m from tablename group by 班级 ) b on a.班级=b.班级 and a.分数=b.m
SELECT Table1.班级, 姓名,A.最高分数 FROM Table1 INNER JOIN (SELECT 班级, MAX(分数) AS 最高分数 FROM Table1 GROUP BY 班级) A ON Table1.班级=A.班级 AND Table1.分数=A.最高分数
将victorycyz(中海)和楼上的语句中加上显示备注的就OK.select a.班级, a.姓名,a.分数 AS 最高分数,a.备注 from tablename a join ( select 班级, max(分数) as m from tablename group by 班级 ) b on a.班级=b.班级 and a.分数=b.m
SELECT A.班级, A.姓名, A.分数 FROM TABLENAME AS A LEFT JOIN ( SELECT 班级, MAX(分数) FROM TABLENAME GROUP BY 班级 ) AS B ON A.班级 = B.班级表名与字段名你自己改吧!!
select * from T1 where 分数 in (select max(分数) from T1 group by 班级)
SELECT 班级, 姓名,MAX(分数) AS 最高分数 FROM TableX GROUP BY 班级, 姓名
select a.班级, a.姓名,a.分数 AS 最高分数
from tablename a join
( select 班级, max(分数) as m
from tablename
group by 班级
) b
on a.班级=b.班级 and a.分数=b.m
FROM Table1
INNER JOIN
(SELECT 班级, MAX(分数) AS 最高分数 FROM Table1 GROUP BY 班级) A
ON Table1.班级=A.班级 AND Table1.分数=A.最高分数
from tablename a join
( select 班级, max(分数) as m
from tablename
group by 班级
) b
on a.班级=b.班级 and a.分数=b.m
FROM TABLENAME AS A
LEFT JOIN (
SELECT 班级, MAX(分数)
FROM TABLENAME GROUP BY 班级
) AS B
ON A.班级 = B.班级表名与字段名你自己改吧!!
楼上的,你看清楚 skyinfo(一剑仙) 那条语句的问题了吗?先把语句写对了再讨论速度!