举一反三
- 以下删除stu表成绩小于60的记录，可是实现的代码是（） A: delete stu where score<60; B: delete from stu where score<60; C: delete stu D: truncate stu where score<60;
- 已知有score表,将表中score字段中的值统一提高20%,写出SQL语句____
- 在SCORE表中,按成绩升序排列存入NEW表中,应使用的SQL语句是( ). A: SELECT * FROM SCORE ORDER BY 成绩 B: SELECT * FROM SCORE ORDER BY 成绩 INTO TABLE NEW C: SELECT * FROM SCORE ORDER BY 成绩 TO NEW D: SELECT * FROM SCORE ORDER BY 成绩 INTO CURSOR NEW
- 在SCORE表中，按成绩升序排列存入NEW表中，应使用的SQL语句是 A: SELECT * FROM SCORE ORDER BY 成绩 INTO NEW B: SELECT * FROM SCORE ORDER BY 成绩 INTO CURSOR NEW C: SELECT * FROM SCORE ORDER BY 成绩 INTO TABLE NEW D: SELECT * FROM SCORE ORDER BY 成绩 TO NEW
- 下列选项中,用于将 student 表按照 gender 字段进行分组查询,并且查询 score 字段值之和小于300的分组的 SQL 语句是 A: SELECT gender , SUM ( score ) FROM student GROUP BY gender HAVING SUM ( score )<;300; B: SELECT gender , SUM ( score ) FROM student GROUP BY gender WHERE SUM ( score )300; C: SELECT gender , SUM ( score ) FROM student WHERE SUM ( score )<;300 GROUP BY gender ; D: 以上语句都不对
内容
- 0
查询Score表中成绩在60到80之间的所有记录
- 1
查询Score表中的所有数据。
- 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存储在HBase中，查找student表中id:2015001的{score:math｝成绩，其id作为行键，正确的命令是 A: get 'student', '2015001', 'score:math B: get 'student', '2015001', {COLUMN=>'score:math'} C: get 'student', '2015001', {COLUMN='score:math'} D: get 'student', '2015001', {'score:math'}
- 4
在如下结构体中，不正确的是( )。 A: struct student {char name[10]; float score; }; B: struct stu[5] {char name[10]; float score; }; C: struct student {char name[10]; float score; } stu[5]; D: struct {char name[10]; float score; }stu[5];