有个表叫student表 起了别名s 但是我点不出任何东西 都是手动敲的
怎么解决 谢谢!
SELECT s.studentno,studentname,subjectname,studentresult
FROM student s
INNER JOIN result r
ON s.StudentNo=r.StudentNo
INNER JOIN subject
sub
ON r.SubjectNo=sub.SubjectNo
WHERE subjectname=‘JAVA第一学年’ AND studentresult>=80
ORDER BY studentresult DESC
LIMIT 10 OFFSET 0