Student表
SC表
投影查询
SELECT id,name,classno FROM Student
GO
选择查询
SELECT * FROM Student WHERE sex = '男'
GO
连接查询
SELECT * FROM Student,SC WHERE SC.classno=Student.classno
GO
Student表
SC表
投影查询
SELECT id,name,classno FROM Student
GO
选择查询
SELECT * FROM Student WHERE sex = '男'
GO
连接查询
SELECT * FROM Student,SC WHERE SC.classno=Student.classno
GO