请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.下面选项中，查询student表中id值不在2和5之间的学生的SQL语句是（ ）。选项： A:SELECT * FROM student where id!=2,3,4,5;; B:SELECT * FROM student where id not between 5 and 2;; C:SELECT * FROM student where id not between 2 and 5;; D:SELECT * FROM student where id not in 2,3,4,5;
- 2.以下关于内连接语句描述正确的是（） 选项： A:select * from student join student2 where stduent=studetn2; B:select * from student join student2 where stduent.id=studetn2.id; C:select * from student join student2 on stduent.id=studetn2.id; D:select * from student ,student2 on stduent.id=studetn2.id;
- 3.哪些语句可以删除数据表中的数据 A: UPDATE STUDENT SET SEX = 'M' WHERE ID = 2 B: INSERT INTO STUDENT (ID,NAME,SEX) VALUES (3,'张三','W') C: DELETE FROM STUDENT WHERE ID = 3 D: SELECT * FROM STUDENT
- 4.哪些语句可以删除数据表中的数据 选项： A、UPDATE STUDENT SET SEX = 'M' WHERE ID = 2 B、INSERT INTO STUDENT (ID,NAME,SEX) VALUES (3,'张三','W') C、DELETE FROM STUDENT WHERE ID = 3 D、SELECT * FROM STUDENT
- 5. 若想查询student表中name为空值的记录，则正确的SQL语句是 1分 选项： A:select * from student where name = null; B:select * from student where name link null; C:select * from student where name = 'null'; D:select * from student where name is null;
- 6.以下（）语句从表student中提取前5条记录。（选一项） 选项： A、select * from student where rowcount=5 B、select TOP of 5 * from student C、select TOP 5 * from student D、select * from student where rowcount<=5
- 7.查询所有非计算机系学生的信息，不正确的SQL语句是：（） 选项：SELECT * FROM Student WHERE Sdept != 'CS';#SELECT * FROM Student WHERE NOT Sdept = 'CS';#SELECT * FROM Student WHERE NOT Sdept IN ('CS');#SELECT * FROM Student WHERE Sdept IN ('MA', 'IS');
- 8.以下()语句从表student中提取前5条记录。( )(单选)A、select * from student where rowcount=5B、select TOP of 5 * from studentC、select TOP 5 * from studentD、select * from student where rowcount<=5
- 9.查询student表中的所有非空email信息，以下语句正确的是 选项： A:Select email from student where email not is null B:Select email from student where emailnull C:Select email from student where email is not null D:Select email from student where email！=null
- 10.查询student表中的所有非空email信息，以下语句正确的是（ ）。 选项： A:Select email from student where email !=null B:Select email from student where email null C:Select email from student where email not is null D:Select email from student where email is not null
- 11.查询Student表中的所有非空Email信息，以下语句正确的是（ ）。选项： A:SELECT Email FROM Student WHERE Email ！= NULL；; B:SELECT Email FROM Student WHERE Email NOT IS NULL；; C:SELECT Email FROM Student WHERE Email <> NULL；; D:SELECT Email FROM Student WHERE Email IS NOT NULL；
- 12.查询student表中的所有非空email信息, 以下语句正确的是()。 选项： A:Select email from student where email !=null B: Select email from student where email not is null C:Select email from student where email <> null D:Select email from student where email is not null
- 13.使用嵌套查询，得到在SC表中Grade高于90分的学生的基本信息，正确的SQL语句是( )。选项： A:Select * from Student where Sno = (Select Sno from SC where Grade >90); B:Select * from Student where Sno In (Select Sno from SC where Grade >90); C:Select * from Student where Sno Not In (Select Sno from SC where Grade >90); D:Select * from Student where Sno Exists (Select Sno from SC where Grade >90)
- 14.在学生表students中查询所有姓张的同学,可以使用语句( ) 选项： A、select * from student where name="张%"; B、select * from student where name like "张*"; C、select * from student where name like "%张"; D、select * from student where name like "张%";
- 15. 查询所有非计算机系学生的信息，不正确的SQL语句是：（ ） 选项： A、 SELECT * FROM Student WHERE Sdept != 'CS'; B、 SELECT * FROM Student WHERE NOT Sdept = 'CS'; C、 SELECT * FROM Student WHERE Sdept IN ('MA', 'IS'); D、 SELECT * FROM Student WHERE NOT Sdept IN ('CS');
