查找数据表S中所有的记录，可以用（ ）。
A: SELECT * FROM S
B: SEARCH * FROM S
C: INSERT * FROM S
D: SEARCH S
A: SELECT * FROM S
B: SEARCH * FROM S
C: INSERT * FROM S
D: SEARCH 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
- 下列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
- delete from S语句可以删除表S中的所有数据并将表S的定义一并删除。( )
- 查询选修了课程号为‘C2’的学生号和姓名,若用下列SQL的SELECT语句表达时, 是错误的? A: SELECT S.S B: ,SNAME FROM S WHERE S C: = (SELECT SS D: FROM SC WHERE C E: =‘C2’) F: SELECT S.S G: ,SNAME FROM S,SC WHERE S H: = SS I: AND C J: =‘C2’ K: SELECT S.S L: ,SNAME FROM S,SC WHERE S M: = SS N: AND C O: =‘C2' ORDER BY S P: Q: SELECT S.S R: ,SNAME FROM S WHERE S S: IN(SELECT SS T: FROM SC WHERE C U: =‘C2' )
- 下列SQL语句中，正确的是（ ）。 A: SELECT S B: , SNAME FROM SC GROUP BY S C: D: SELECT S E: FROM SC GROUP BY S F: HAVING COUNT(*)>3 G: SELECT S H: ,Cname FROM SC GROUP BY S I: WHERE COUNT(*)>3 J: SELECT S K: FROM SC WHERE COUNT(*)>3 GROUP BY S L: