Tobesix的博客表格详情: student表: teacher表: ...23.查询“张旭“教师任课的学生成绩 select * from score where cno=(select cno from course where tno=(select tno from teacher where tname="张旭"));...
moue0350的博客在WHERE语句中,AND和OR同时存在的时候,通常AND运算符的优先级大于OR运算符。 condition1 OR condition2 AND condition3 实际上是 condition1 OR (condition2 AND condition3) IN运算符允许根据一行记录中...