给一张学生表,有姓名,分数
求:
1、最高分同学的名字
2、同名同学姓名
1、
SELECT
student.sName
FROM
student
GROUP BY
student.sName
ORDER BY
MAX( student.score ) DESC
LIMIT 1
2、
SELECT
sName
FROM
student
GROUP BY
sName
HAVING
count( sName ) > 1
给一张学生表,有姓名,分数
求:
1、最高分同学的名字
2、同名同学姓名
1、
SELECT
student.sName
FROM
student
GROUP BY
student.sName
ORDER BY
MAX( student.score ) DESC
LIMIT 1
2、
SELECT
sName
FROM
student
GROUP BY
sName
HAVING
count( sName ) > 1