查询选修了课程号为“C1”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,错误的是( )。 A: SELECT SNAME,AGE FROM S WHERE B: S#=(SELECT S C: S#FROM SC WHERE D: C#='C1') E: SELECT SNAME,AGE FROM S,SC WHERE F: S#=S G: S# AND S H: C#='C1' I: SELECT SNAME,AGE FROM S,SC WHERE J: S#=S K: S# AND S L: C#='C1' ORDERBY M: S# N: SELECT SNAME,AGE FROM S WHERE O: S#=(SELECT S P: S# FROM SC WHERE S Q: C#='C1')
查询选修了课程号为“C1”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,错误的是( )。 A: SELECT SNAME,AGE FROM S WHERE B: S#=(SELECT S C: S#FROM SC WHERE D: C#='C1') E: SELECT SNAME,AGE FROM S,SC WHERE F: S#=S G: S# AND S H: C#='C1' I: SELECT SNAME,AGE FROM S,SC WHERE J: S#=S K: S# AND S L: C#='C1' ORDERBY M: S# N: SELECT SNAME,AGE FROM S WHERE O: S#=(SELECT S P: S# FROM SC WHERE S Q: C#='C1')
“查询选修了3门以上课程的学生的学生号”,正确的SQL语句是( )。 A: SELECT S#FROM SC GROUP BY S#WHERE COUNT(*)>3 B: SELECT S#FROM SC GROUP BY S#HAVING COUNT(*)>3 C: SELECT S#FROM SC ORDER BY S#HAVING COUNT(*)>3 D: SELECT S#FROM SC ORDER BY S#WHERE COUNT(*)>3
“查询选修了3门以上课程的学生的学生号”,正确的SQL语句是( )。 A: SELECT S#FROM SC GROUP BY S#WHERE COUNT(*)>3 B: SELECT S#FROM SC GROUP BY S#HAVING COUNT(*)>3 C: SELECT S#FROM SC ORDER BY S#HAVING COUNT(*)>3 D: SELECT S#FROM SC ORDER BY S#WHERE COUNT(*)>3
查找数据表S中所有的记录,可以用( )。 A: SELECT * FROM S B: SEARCH * FROM S C: INSERT * FROM S D: SEARCH S
查找数据表S中所有的记录,可以用( )。 A: SELECT * FROM S B: SEARCH * FROM S C: INSERT * FROM S D: SEARCH S
Sometimes, a man’s way of handling a problem ______ a woman’s A: different from B: differ from C: distinct from D: is distinct from
Sometimes, a man’s way of handling a problem ______ a woman’s A: different from B: differ from C: distinct from D: is distinct from
下列SQL语句中,正确的是( )。 A: SELECT S B: , SNAME FROM SC GROUP BY S C: SELECT S D: FROM SC GROUP BY S E: HAVING COUNT(*)>3 F: SELECT S G: ,Cname FROM SC GROUP BY S H: WHERE COUNT(*)>3 I: SELECT S J: FROM SC WHERE COUNT(*)>3 GROUP BY S
下列SQL语句中,正确的是( )。 A: SELECT S B: , SNAME FROM SC GROUP BY S C: SELECT S D: FROM SC GROUP BY S E: HAVING COUNT(*)>3 F: SELECT S G: ,Cname FROM SC GROUP BY S H: WHERE COUNT(*)>3 I: SELECT S J: FROM SC WHERE COUNT(*)>3 GROUP BY S
基于表S创建视图R的SQL语句是【 】 A: CREATE R AS SELECT 学号,姓名 FROM S B: CREATE TABLE R AS SELECT 学号,姓名 FROM S C: CREATE VIEW R AS SELECT 学号,姓名 FROM S D: CREATE R FROM SELECT 学号,姓名 AS S
基于表S创建视图R的SQL语句是【 】 A: CREATE R AS SELECT 学号,姓名 FROM S B: CREATE TABLE R AS SELECT 学号,姓名 FROM S C: CREATE VIEW R AS SELECT 学号,姓名 FROM S D: CREATE R FROM SELECT 学号,姓名 AS S
若要删除数据库中已经存在的表S,可用_________语句。 A: DELETE TABLE S B: DELETE FROM S C: DROP TABLE S D: DROP FROM S
若要删除数据库中已经存在的表S,可用_________语句。 A: DELETE TABLE S B: DELETE FROM S C: DROP TABLE S D: DROP FROM S
How is the statue being made, and what is it being made from A: It's being made from a piece of metal. B: It's being carved from a single block of standstone. C: It's assembled with many blocks of stones. D: It's purely natural.
How is the statue being made, and what is it being made from A: It's being made from a piece of metal. B: It's being carved from a single block of standstone. C: It's assembled with many blocks of stones. D: It's purely natural.
Why was the journey different from the author’s expectation from the very beginning?
Why was the journey different from the author’s expectation from the very beginning?
Hector’s mother is from Mexico.
Hector’s mother is from Mexico.