请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.student表中有姓名字段name，并且存在name为“sun%er”的记录。下面选项中，可以匹配“sun%er”字段值的SQL语句是（）。A.SELECT * FROM student WHERE name LIKE sun%er; 选项： A:SELECT * FROM student WHERE name LIKE ' %%%'; B:SELECT * FROM student WHERE name LIKE ' %\%%'; C:SELECT * FROM student WHERE name= ' sun%er';
- 2.若想查询student表中name为空值的记录，则正确的SQL语句是2分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;
- 3. 若想查询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;
- 4.下列查询语句，语法错误的是 A: SELECT id,name FROM student WHERE id = 4; B: SELECT id,name FROM student WHERE name = wusong; C: SELECT name,grade FROM student WHERE grade >= 80; D: SELECT * FROM student WHERE gender = '男';
- 5.有学生表Student(S# char(8), Sname char(10), Ssex char(2),Sage integer, D# char(2), Sclass char(6))。若要“检索名字为张某某的所有同学姓名”，SQL语句正确的是（ ）。选项： A:Select Sname From Student Where Sname Like ‘张_ _’;; B:Select Sname From Student Where Sname Like ‘张%’;; C:Select Sname From Student Where Sname Like ‘张_’;; D:Select Sname From Student Where Sname Not Like ‘张_ _’;
- 6.从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 '周_'
- 7.若需要在goods表中查询所有空调的数据，可以使用的SQL语句是（ ）。选项： A:SELECT * FROM goods WHERE name=’空调’ B:SELECT * FROM goods WHERE name LIKE '%空调%' C:SELECT * FROM goods WHERE name LIKE '空调' D:SELECT * FROM goods WHERE name= '%空调%'
- 8.SQL语句中，下列查询姓张的学生的语句正确的是( )。 选项： A: SELECT*FROM表名WHERE姓名LIKE'张“ B: SELECT*FROM表名WHERE姓名='张%’ C: SELECT*FROM表名WHERE姓名='张' D: SELECT*FROM表名WHERE姓名LIKE张%'
- 9.SQL语句中，下列查询姓张的学生的语句正确的是（ ）。 选项： A、SELECT * FROM 表名 WHERE 姓名 LIKE '张%' B、SELECT * FROM 表名 WHERE 姓名 = '张%' C、SELECT * FROM 表名 WHERE 姓名 = '张' D、SELECT * FROM 表名 WHERE 姓名 LIKE '张'
- 10.SQL语句中，下列查询姓张的学生的语句正确的是（ ） 选项： A:SELECT * FROM 表名 WHERE 姓名 = '张%' B:SELECT * FROM 表名 WHERE 姓名 LIKE '张' C:SELECT * FROM 表名 WHERE 姓名 LIKE '张%' D:SELECT * FROM 表名 WHERE 姓名 = '张'
-
11.下列语句执行时报错的是哪一条()。 选项： 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’; - 12.要查询book表中所有书名中以“计算机”开头的书籍情况，可用（ ）语句 选项： A:SELECT * FROM book WHERE book_name LIKE ‘计算机*’ B:SELECT * FROM book WHERE book_name LIKE ‘计算机_’ C:SELECT * FROM book WHERE book_name = ‘计算机%’ D:SELECT * FROM book WHERE book_name Like ‘计算机%’
- 13.查询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；
- 14.查询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
- 15.查询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
- 16.查询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
- 17.查询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;
- 18.查询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
- 19.查询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 nul1 D: Select email from student where email is not null
- 20.查询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
