多表查询:运用AS子句,排序,分页查询
例:SELECT a.StudentNo AS 学号,StudentName AS 学生姓名,SubjectName AS Java第一学年,StudentResult AS 成绩 FROM student AS a INNER JOIN result AS s ON a.StudentNo=s.StudentNo INNER JOIN subject AS j ON s.SubjectNo=j.SubjectNo WHERE J.SubjectName='java第一学年’AND StudentResult>=80 ORDER BY StudentResult DESC,s.StudentNo DESC LIMIT 0,10
19、MYSQL多表查询实例
最新推荐文章于 2022-08-14 16:52:07 发布