如何查询表中的最大值

[lunhuifengzheng]

请教下，如何查询表中的最大值，比如说一个TEST表，然后表中存储课程号（K）和成绩(C),请问下如何查询出每门课的最大成绩值。用一条SQL语句。

[百年树人]

select K,SUM(C) AS C FROM TB GROUP K

[JonasFeng]

SELECT K,MAX(C) AS C
FROM TEST
GROUP BY K 

[寻找Python之禅]

select k, max(C) as max_grade
from TEST
group by k

[lunhuifengzheng]

谢谢大家了

[jieon]

SELECT K,MAX(C) AS C FROM TEST GROUP BY K

[lunhuifengzheng]

我想再请问下，如果是增加了另外一列是M（名字），然后根据类别查询每个类别最大值的全部信息怎查