请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.从student表中查询学生姓名、年龄和成绩，结果按照年龄降序排序，年龄相同的按照成绩升序排序，下面SQL语句正确的是（ ）？选项： A:select name, age, score from student order by age desc , score;; B:select name, age, score from student order by age , score asc;; C:select name, age, score from student order by 2 desc , 3 asc;; D:select name, age, score from student order by 1 desc , 2 ;
- 2.从student表中查询学生姓名、年龄和成绩，结果按照年龄降序排序，年龄相同的按照成绩升序排序，下面SQL语句正确的是： 选项： A、select name, age, score from student order by age desc , score; B、select name, age, score from student order by age , score asc; C、select name, age, score from student order by 2 desc , 3 asc; D、select name, age, score from student order by 1 desc , 2；
- 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 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’; - 5.下列查询语句，语法错误的是 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 = '男';
- 6.在学生表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 "张%";
- 7.在MaxCompute中通过SQL创建了一张分区表，create table t_student(name string,score bigint), 下面的SQL语句中语法正确的有:（）。 选项： A、select * from t_student order by score limit 100; B、select * from t_student order by score; C、select name, score as p from t_student order by p limit 100; D、select name, score as s from t_student order by score limit 100;
- 8. SELECT DISTINCT name,gender FROM student，该SQL语句的功能为查询student表中name和gender记录，并保证没有重复记录
- 9.哪些语句可以删除数据表中的数据 选项： 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
- 10.使用SELECT语句查询student表中name字段和sex字段的数据
- 11. (单选题)哪些语句可以删除数据表中的数据 选项： 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
- 12.检索student表中的前3条记录信息，可以使用下面（ ）SQL语句。选项： A:select * from student limit 1,3;; B:select * from student limit 1;; C:select * from student;; D:select * from student limit 3;
- 13.阅读下面的SQL语句: SELECT DISTINCT name,gender FROM student; 关于此SQL语句的描述,正确的是
- 14.查询表student（sno,sname,sage,ssex,sphone,cno）中所有学生的所有信息，下面语句不正确的是（ ） 选项： A、select * from student B、select sno,sname,sage,ssex,sphone,cno from student C、select from student D、SELECT * FROM STUDENT
- 15.使用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）=‘张’
- 16.查询所有非计算机系学生的信息，不正确的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');
- 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 Email <> NULL；; 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 <> null ; D:Select email from student where email is not null
- 20.查询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;
