SELECTstudent.StudentNo,student.StudentName,`subject`.SubjectName,result.StudentResult
FROMstudent,`subject`,result
WHEREresult.StudentResult>80 AND `subject`.SubjectName='《JAVA第一学年》' AND student.StudentNo
IN(SELECTa.StudentNo
FROM (SELECTstudent.StudentNo
FROMstudent,`subject`,result
WHERE`subject`.SubjectName='《JAVA第一学年》'
ORDER BYresult.StudentResult DESC
LIMIT 10)AS a)
就是在加一层select