题目内容
集合操作可用来连接两个结果集，所有的集合操作语句都可以转换成不含集合操作的单语句查询。
查看答案
搜索结果不匹配？点我反馈
更多问题
连接查询必须涉及到至少两张不同的表。
查询计算机系任意学生选修过的课程号，可以使用如下语句：SELECT DISTINCT CnoFROM SCWHERE Sno IN (SELECT SnoFROM StudentWHERE Sdept = 'CS');
The contest takes up to seven days to complete and is a challenging test of fitness and strength even for world-class athletes who compete for distinction and a cash prize.
No one paid any attention to this odd-looking man who might as well have been invisible.
微信支付 
支付宝支付