请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.查询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
- 2.查询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
- 3.查询Student表中的所有非空Email信息，以下语句正确的是( )。 选项： A:SELECT Email FROM Student WHERE Email! = NULL B:SELECT EmaU FROM Student WHERE Email NOT IS NULL C:SELECT Email FROM Student WHERE Email<>NULL D:SELECT EmaH FROM Student WHERE Email IS NOT NULL
- 4.查询student表中的所有非空emai1信息,以下语句正确的是 选项： A: Select email from student where email notis null B: Select email from student where email<>null C: Select email from student where emailis not null D: Select email from student where email! =null
- 5.查询student表中的所有非空emai1信息,以下语句正确的是 选项： A: Select email from student where email notis null B: Select email from student where email<>null C: Select email from student where emailis not null D: Select email from student where email! =null
- 6.下面哪一个语句,显示没有Email地址的教师姓名() 选项： A、Select name from teacher where email=NULL; B、Select name from teacher where email C、Select name from teacher where email is NULL; D、Select name from teacher where emailis not NULL;
- 7. 查询所有非计算机系学生的信息，不正确的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');
- 8.使用SQL语句从Student表中查询所有姓张的同学的信息，正确的命令是（） 选项： A:SELECT * FROM Student WHERE LEFT（姓名，1）=‘张’ B:SELECT * FROM Student WHERE RIGHT（姓名，1）=‘张’ C:SELECT * FROM Student WHERE TRIM（姓名，1）=‘张’ D:SELECT * FROM Student WHERE STR（姓名，1）=‘张’
- 9.使用教学（STC）数据库，与如下查询语句等价的是（ ）。 SELECT *FROM Student WHERE Sdept = 'CS' EXCEPT SELECT * FROM Student WHERE Sage <= 19; 选项： A、SELECT * FROM Student WHERE Sdept = 'CS' AND Sage > 19 B、SELECT * FROM Student WHERE Sdept = 'CS' AND Sage <= 19 C、SELECT * FROM Student WHERE Sdept = 'CS' OR Sage <= 19 D、SELECT * FROM Student WHERE Sdept = 'CS' OR Sage > 19
- 10.使用嵌套查询，得到在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)
- 11.使用嵌套查询，得到在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)
- 12.使用嵌套查询，得到在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)
- 13.查询语句SELECT *FROM StudentWHERE Sdept = 'CS'EXCEPTSELECT *FROM StudentWHERE Sage <= 19;可以等价为：（ ） 选项：A、SELECT * FROM Student WHERE Sdept = 'CS' AND Sage > 19; B、SELECT * FROM Student WHERE Sdept = 'CS' AND Sage <= 19; C、SELECT * FROM Student WHERE Sdept = 'CS' OR Sage <= 19; D、SELECT * FROM Student WHERE Sdept = 'CS' OR Sage > 19;
- 14.从Student表检索年龄为20岁的学生信息，已知年龄字段是数值类型，最规范的SQL语句是( )。 选项： A、Select * From Student where Sage=20 B、Select * From Student where Sage='20' C、Select * From Student where Sage=【20】 D、Select * From Student where Sage EQUAL 20
- 15.从Student表检索年龄为20岁的学生信息，已知年龄字段是数值类型，最规范的SQL语句是( )。 选项： A、Select * From Student where Sage=20 B、Select * From Student where Sage='20' C、Select * From Student where Sage=【20】 D、Select * From Student where Sage EQUAL 20
