皮皮学,免费搜题
登录
搜题
【单选题】
有学生表s、课程表c和选课表sc,结构分别如下: s(学号, 姓名, 性别, 年龄) c(课程号, 课程名, 学分) sc(学号, 课程号, 成绩) 检索学号、姓名和学生所修课程的课程名和成绩,正确的SQL命令是______。
A.
SELECT 学号, 姓名, 课程名, 成绩 FROM s, c, sc WHERE s.学号=sc.学号 AND sc.学号=c.学号
B.
SELECT 学号, 姓名, 课程名, 成绩 FROM s INNER JOIN sc ON s.学号=sc.学号 INNER JOIN c ON sc.课程号=c.课程号
C.
SELECT s.学号, 姓名, 课程名, 成绩 FROM s INNER JOIN sc ON s.学号=sc.学号 INNER JOIN c ON sc.课程号=c.课程号
D.
SELECT s.学号, 姓名, 课程名, 成绩 FROM s INNER JOIN sc INNER JOIN c ON s.学号=sc.学号 ON sc.课程号=c.课程号
拍照语音搜题,微信中搜索"皮皮学"使用
参考答案:
参考解析:
知识点:
.
..
皮皮学刷刷变学霸
举一反三
【简答题】Does she still want to go to the lake? Or has she changed her mind? It’s not clear. (whether... or...) _________________________________________________________________________________________
【简答题】Does she still want to go to the lake? Or has she changed her mind? It’s not clear. (whether... or...) ___________________________________________________________
【简答题】What does the mother want to tell through the fact that her daughter has bought a truck instead of a car and that she is still watching cartoons?
【简答题】Complete this text with the best word for each gap,a), b) or c) Laura has always been ambitious. She is still at secondary school, but she has already 1 on a career plan. She knows exactly what she wa...
【单选题】What message does the UK boss want to convey?
A.
When an employee is transferred to another post, he / she will get a higher salary.
B.
It is natural for an employee to be promoted after he / she has worked for a long time.
C.
An employee’s position in a company will be directly related to his / her abilities.
D.
In a company, an employee’s functional role is still important.
【单选题】糖异生的生理意义不包括()
A.
维持运动中血糖稳定
B.
有利于乳酸利用
C.
促进脂肪氧化分解供能
D.
有利于丙酮酸的利用
E.
促进氨基酸代谢
【简答题】Armida Scarpa believes that stories, even in authentic English, can be used from the very beginning. She uses an authentic text of Goldilocks with her class of seven-year-old who are in their second y...
【单选题】Having no interest in the fashion industry, why does Andrea still want to work for Miranda?
A.
Because she needs money for rent.
B.
Because it's a job millions of girls kill for.
C.
Because she wants to become a dragon lady like Miranda.
D.
Because if she sticks it out for one year, she can do what she came to New York to do.
【单选题】客户关系管理简称为( )
A.
ERP
B.
MIS
C.
CRM
D.
HRM
【简答题】Complete this text with the best word for each gap, A, B or C. Laura has always been ambitious. She is still at secondary school, but she has already 1 on a career plan. She knows exactly what she wan...
相关题目: