请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.查询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；
- 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 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
- 4.查询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
- 5.查询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
- 6.查询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
- 7.查询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
- 8.查询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 emailnull; D、SELECT email FROM Student Where email is not null;
- 9.查询student表中的所有非空email信息，以下语句正确的是 选项： A:Select email from student where email not is null B:Select email from student where email＆lt;＆gt;null C:Select email from student where email is not null D:Select email from student where email！=null
- 10.在学生表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 "张%";
- 11.查询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
- 12.查询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
- 13.查询student表中的所有非空email信息以下语句正确的是 选项： A:Select email from student where email notis null B:Select email from student whereemail<>null C:Select email from student where email isnot null D:Select email from student where email!=null
- 14.下面哪一个语句,显示没有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;
-
15.下列语句执行时报错的是哪一条()。 选项： A、select
id,name from student order by name; B、select
id,name,count(*) from student group by id; C、select
id,name from student where sex=’f’; D、select
count(*) as total from student where sex=’f’; - 16.数据库中有一张表名称为Student，有列Name，Age，IDCard，Sex。要求写SQL语句查询出表中所有的数据，下列哪个SQL语句是正确的（）选项： A:Select * From Student B:Select Name From Student C:Select Name,Age,IDCard From Student D:Select Name Age IDCard Sex From Student
- 17.从Student表检索姓周的学生，对应的SQL语句是( )。选项： A:Select * From Student Where Sname like '周%'; B:Select * From Student Where Sname like '%周'; C:Select * From Student Where Sname like '_周'; D:Select * From Student Where Sname like '周_'
- 18.使用教学（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
- 19.若需要在goods表中查询价格为空的数据，可以使用的SQL语句是（ ）。选项： A:SELECT * FROM goods WHERE price IS NULL B:SELECT * FROM goods WHERE price=NULL C:SELECT * FROM goods WHERE price Like NULL D:SELECT * FROM goods WHERE price=’NULL’
- 20.使用嵌套查询，得到在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)
