?? 新建 文本文檔 (3).txt
字號:
select distinct coursename,studentname,teachername,grade
from students,courses,enrolls,sections,teachers
where courses.course=sections.course and sections.course=enrolls.course and students.student=enrolls.student and teachers.teacher=sections.teacher and students.student=enrolls.student
group by enrolls.student,courses.coursename,students.studentname,teachers.teachername,enrolls.grade
select distinct coursename,studentname,teachername,grade
from students,courses,enrolls,sections,teachers
where courses.course=sections.course and sections.course=enrolls.course and students.student=enrolls.student and teachers.teacher=sections.teacher and students.student=enrolls.student
group by enrolls.student,courses.coursename,students.studentname,teachers.teachername,enrolls.grade
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -