数据库中from后的子查询与select后的子查询
#from后的子查询
SELECT course.*
#将from()括号中重新命名了一个表且必须重命名,且表中只有avg(grade)与Cno两个数据
FROM (SELECT avg(grade),Cno
FROM sc
GROUP BY Cno) avg
INNER JOIN course
ON avg.Cno = course.Cno
#SELECT后的子查询
#子查询中只能查询一项数据,若把Sdept改为两个数据或者*,会报1241的错误SELECT sc.*,(SELECT student.Sdept FROM student WHERE student.Sno = sc.Sno)FROM sc